Excel Pivot Chart Pie Chart: Multiple Columns Explained

Yes, you can make a pie PivotChart in Excel, but a pie chart can show only one data series at a time. If your PivotTable has multiple value columns, choose one measure for the pie, use the other fields as categories or filters, or create separate charts; a standard pie cannot combine several independent measures into one meaningful set of slices.

What “multiple columns” can mean

The answer depends on what you mean by columns. In a PivotTable, fields can appear in the Columns area, and several fields can also appear in Values. Separately, your source data may have several measure columns, such as Sales, Cost, and Profit. Those layouts are not interchangeable in a pie chart.

A pie chart needs one set of numbers and a matching set of category names. For example, one value per product can show each product’s share of total sales. Excel cannot use Sales and Profit as two different series in the same pie and still make every slice a comparable part of one whole. Nor does placing fields in the PivotTable Columns area create extra pie dimensions: it can split the data into series, which a pie chart cannot display together as one pie.

So first identify whether the extra columns are categories, time periods, or separate measures. That distinction determines whether to rearrange the PivotTable, filter the view, reshape the data, or choose another chart type.

How a pie PivotChart uses PivotTable fields

A PivotChart is linked to a PivotTable. In a pie chart, the PivotTable’s category field supplies the slice labels, and its one selected value field supplies the slice sizes. A field in Filters can limit which records contribute to the pie. A field in Columns may create multiple series or groups, which is usually not suitable for one pie.

For a straightforward product-sales example, the PivotTable layout should be:

Rows: Product
Values: Sum of Sales
Filters: Region, Year, or another field used to select a subset
Columns: Empty, unless you have a specific reason to split the data and will select just one resulting series

Each product then becomes a slice, and the total of the displayed sales values is the whole represented by the pie. If you put Region in Columns, Excel may create a separate value series for each region. A pie chart is not designed to show those series together as a set of comparable pies. Filter to one region at a time, or choose a chart that handles multiple series.

Create a pie PivotChart in Excel

In Excel for Microsoft 365 on Windows, start with a PivotTable based on tidy source data: one header row, one record per row, and separate columns for fields such as Product, Region, and Sales. Click inside the PivotTable, then use these steps:

In the PivotTable Fields pane, drag the category field, such as Product, to Rows.
Drag the numeric field, such as Sales, to Values. If Excel uses Count instead of Sum, open the field’s menu in Values, choose Value Field Settings, and select Sum if the source values are numeric.
Move any field that should select the displayed data to Filters. You can also use a field in Rows or Columns and filter its items, but keep the chart to one series.
Click inside the PivotTable and select PivotTable Analyze > PivotChart.
In the Insert Chart dialog, choose Pie, select a pie subtype, and click OK.

You can also insert a PivotChart from the Insert tab while the PivotTable is selected. Ribbon wording and placement can vary slightly with window size and Excel updates. On a Mac, select the PivotTable and use the PivotTable Analyze tab or the Insert tab to find the PivotChart command; dialog layout can differ from Windows. Excel for the web has more limited chart and PivotTable editing controls than the desktop app, so use desktop Excel if the PivotChart command or a needed setting is unavailable.

To show the proportion of each slice, select the chart, use the Chart Elements button (the plus sign beside the chart) or the chart design controls, and add Data Labels. In the label formatting options, choose percentage, category name, or both. Percentages are calculated from the values represented in the current chart, so filtering the PivotTable can change the denominator.

What to do when you have several value columns

Suppose your source table has columns for Product, Sales, and Profit, and you add both Sales and Profit to the PivotTable’s Values area. Those are two different measures. The clearest solution depends on the question the chart is meant to answer:

Show sales mix: Keep Sum of Sales as the only value field in the pie. Remove Profit from Values or leave it in the PivotTable but ensure the chart uses only one series.
Show profit mix: Make a separate pie with Sum of Profit, provided the values are suitable for a pie chart and represent a meaningful whole.
Compare sales and profit by product: Use a clustered bar or column chart instead. It puts both measures side by side for each product, making differences easier to compare.
Show both measures without clutter: Create two small charts with the same product categories and consistent filters. Label each chart clearly so viewers do not mistake one measure for the other.

There is another common source-data layout: one column per month, such as January Sales, February Sales, and March Sales. A PivotChart works more flexibly when the source is reshaped into fields such as Product, Month, and Sales, with one record for each product-month combination. In Excel, Power Query can help convert month columns into rows using Data > From Table/Range, then selecting the month columns and choosing Transform > Unpivot Columns. Load the transformed table and build the PivotTable from it. You can then put Month in Filters and show one month’s product mix, or use a non-pie chart to compare months.

When a pie is appropriate—and when it is not

A pie chart is most useful when the categories are parts of one whole, the values are nonnegative, and the number of slices is small enough to read. It is usually a poor choice for comparing several periods, showing many products, or displaying values that can be negative. A pie also makes it difficult to judge small differences between similar-sized slices.

For example, a single pie showing the share of total sales for four product lines in one selected year can be reasonable. A pie for every year, with each year split by product, is hard to compare across multiple pies and is not what one multi-series pie is designed to do. A 100% stacked bar can make period-to-period shares easier to compare, while a regular clustered bar chart is often better when actual amounts matter more than proportions.

Excel’s doughnut chart is another one-series option, not a way to turn several measures into one comparable pie. Doughnut charts can display multiple rings in some chart layouts, but multiple rings can still be difficult to compare and should be used only when the series have a clear, consistent meaning. For most multi-measure PivotChart questions, a bar or column chart is the more direct alternative.

Common problems and practical fixes

The chart shows an unexpected field or series. Open the PivotChart Fields pane and check the Legend (Series), Axis (Categories), and Values areas. Remove extra fields from the series layout or filter to one series.
The pie has too many slices. Filter to a relevant group, combine minor categories into a justified “Other” category in the source data, or switch to a bar chart. Do not hide important categories merely to make the pie look simpler.
Values appear as counts rather than totals. In Value Field Settings, choose Sum. If Sum is unavailable or Excel continues to count, inspect the source column for numbers stored as text, blanks, or mixed data types, then refresh the PivotTable.
The percentages do not match the whole dataset. PivotTable filters, slicers, and hidden items can change which records are included. Check the active filters and confirm whether the intended denominator is the visible total or the full dataset.
Some slices disappear. Zero values have no visible angle, and negative values cannot be represented as ordinary pie slices. Verify the underlying values and consider a bar chart if negatives are part of the analysis.
New source rows are missing. Refresh the PivotTable after updating its source. For recurring additions, use an Excel Table as the source so the table can expand as rows are added, then refresh the PivotTable.

Changing the chart type does not repair a poorly structured source. Keep numeric measures numeric, use one header row, avoid merged cells in the source range, and use explicit field names. These practices also make it easier to refresh the PivotTable and understand what each slice represents.

PivotChart versus a regular chart

A PivotChart is convenient when viewers need to interactively filter or rearrange a PivotTable’s fields. Its chart responds to PivotTable filters and slicers, which is useful for exploring product mix by region or year. The trade-off is that its layout is controlled by PivotTable fields and chart-type rules. If the PivotChart keeps including extra series or does not offer the layout you need, a regular chart may be simpler.

One option is to create a regular chart from a small, prepared summary range that contains exactly one category column and one value column. A standard chart is less tightly connected to PivotTable field controls, but it gives more flexibility over the chart’s selected range and formatting. If you need the chart to update with filters, you may need to maintain that summary range appropriately or use another reporting approach. Do not assume that changing a PivotChart into a regular chart preserves all PivotTable interactions.

Frequently Asked Questions

Can an Excel pie PivotChart show two value fields?
A pie chart represents one series at a time. Use one value field for the pie, make separate charts for separate measures, or select a bar or column chart to compare both fields.

Can I put a field in the PivotTable Columns area and still use a pie?
You can place a field there, but it can create multiple series. Filter the field to one item or move it to Filters if you want one pie for a selected group. For simultaneous comparisons across its items, choose a chart type that supports multiple series.

How do I show percentages on a PivotChart pie?
Select the chart and add Data Labels, then format the labels to show percentage. Check that the active PivotTable filters reflect the whole you intend to represent, because the percentages relate to the displayed values.

Why does Excel display Count of Sales instead of Sum of Sales?
Excel may treat some entries in the source column as text or encounter mixed data types. Correct the source values, refresh the PivotTable, and set the value field to Sum in Value Field Settings.

Can one pie PivotChart compare different years?
Not as multiple comparable series in one pie. Filter the PivotChart to one year at a time, or use a 100% stacked chart to compare shares across years and a bar chart to compare amounts.

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.