Excel Pivot Pie Chart: Create, Filter, and Fix One

Yes—Excel for Microsoft 365 on Windows can create a pie PivotChart from a PivotTable. Select a cell in the PivotTable, choose PivotTable Analyze > PivotChart, select Pie, and arrange one category field with one numeric value field.

What an Excel pivot pie chart shows

A PivotChart is a chart connected to a PivotTable. The table summarizes source records, and the chart visualizes that summary. A pie PivotChart shows how the parts of one whole are divided among categories—for example, each product’s share of total sales or each department’s share of a company’s headcount.

Unlike a regular pie chart made from selected cells, a PivotChart uses PivotTable fields. You can change which field supplies the categories, filter the records included, and refresh the summary when the underlying data changes. The chart is therefore useful when you want a visual that follows the same grouping and filtering as a PivotTable.

The central requirement is one meaningful total divided into categories. A pie chart is not a good way to compare several different measures or to show change over time. If the slices do not add up to a meaningful whole, a different chart will usually communicate the data more clearly.

When a pie PivotChart is a good choice

Use a pie when the categories are mutually exclusive parts of the same total and the reader needs to understand their relative shares. For instance, a PivotTable could group order revenue by product line, then a pie PivotChart could show each line’s contribution to the revenue represented by the current filters.

Keep the number of categories modest. A chart with three to six clearly different slices is generally easier to read than one with many thin slices. If there are numerous categories, combine small ones into a legitimate “Other” group in the source or summary, or choose a bar chart that can display long category labels more clearly.

Good fit: share of sales by region for one selected year.
Weak fit: sales by month across several years, because time patterns are easier to compare in a line chart.
Weak fit: comparing product revenue and profit in the same pie; those are separate measures, not parts of one total.

Create a pie PivotChart step by step

Prepare the source data as a clean table: use one header row, give every column a unique heading, and avoid blank rows or columns inside the data. Each record should occupy one row.
Click inside the source data and choose Insert > PivotTable. Confirm the data range and choose where to place the PivotTable, then select OK.
In the PivotTable Fields pane, drag a descriptive field such as Product or Region to Rows. Drag a numeric field such as Revenue to Values. Check that the Values area shows a suitable summary, commonly Sum of Revenue.
Click in the PivotTable and choose PivotTable Analyze > PivotChart. In the Insert Chart dialog, choose Pie, select a subtype such as 2-D Pie, and click OK.
Review the result. If the slices represent the wrong categories or a count instead of a total, adjust the PivotTable fields and value summary, then confirm the chart updates as intended.

You can also create a PivotChart from selected source data using Excel’s PivotChart insertion workflow, which creates or uses a PivotTable behind the chart. Building and checking the PivotTable first makes it easier to verify the aggregation before presenting the visual.

Arrange fields for one clear pie

For a standard pie, put the category field in Axis (Categories)—often labeled Rows in the PivotTable—and put the measure in Values. Leave Legend (Series) empty unless you have a specific reason to reorganize the chart. A pie represents one data series; assigning multiple series is not a way to make one pie compare several measures.

Fields in Filters can limit the records included without changing the category field. For example, use Region as the categories, Sum of Revenue as the values, and Year as a report filter. The displayed slices then show the regional shares for the selected year, rather than mixing years into the same total.

Check the value field’s summary method. In the PivotTable, right-click a value and select Summarize Values By to inspect or change the calculation. Numeric revenue is usually summed; a field stored as text may instead be counted. A count can be valid for questions such as orders per category, but it is not a substitute for a revenue total.

Format labels, percentages, and colors

To make a pie understandable without asking readers to estimate each angle, add data labels. Select the chart, use the Chart Elements (+) button beside it, and select Data Labels. To choose what appears, right-click a label and select Format Data Labels. Depending on the options shown, you can display category names, values, percentages, or a combination.

Percentage labels express each visible category as a share of the total represented by the chart. They are not necessarily shares of every record in the original source: if a report filter excludes a year or a slicer limits the data, the percentages describe the filtered total. A value label, such as a currency amount, can be useful alongside the percentage when readers need both the share and its scale.

Use a chart title that names the measure and scope, such as “Share of 2025 Revenue by Region.” Keep labels readable and avoid relying on color alone to identify slices. In the chart formatting controls, choose colors with sufficient contrast; if two adjacent slices look too similar, change the palette or emphasize labels. A 3-D pie may look decorative, but perspective can distort how large slices appear, so a 2-D pie is often easier to compare.

Filter and refresh the chart

A PivotChart can reflect the PivotTable’s field filters. Use the chart’s field buttons or filter controls, when displayed, to select categories, or filter the corresponding field in the PivotTable. To hide the field buttons for a cleaner presentation, select the chart and use PivotChart Analyze > Field Buttons; the exact button choices can depend on the chart and Excel layout.

For a more convenient report control, add a slicer. Select the associated PivotTable, choose PivotTable Analyze > Insert Slicer, select a field such as Year or Region, and click OK. The slicer filters the connected PivotTable and its PivotChart. A timeline is another option for filtering a PivotTable by dates when the source includes a date field.

When source records change, refresh the PivotTable so the chart can use the updated summary. Select the PivotTable and choose PivotTable Analyze > Refresh, or use Data > Refresh All to refresh workbook connections and PivotTables. If new records fall outside a fixed source range, refresh alone may not include them. Using an Excel table as the source helps the range expand when rows are added; then refresh the PivotTable.

Common problems and what to check

The chart shows counts instead of amounts: inspect the Values field summary and check whether the source numbers are stored as numbers rather than text.
Some categories are missing: clear field filters, slicer selections, and label filters. Also check whether a category’s total is zero; a zero has no visible pie slice.
The chart has too many tiny slices: reduce the number of categories, apply a relevant filter, or use a bar chart. Combining categories is appropriate only when the grouping is meaningful and explained.
New rows do not appear: verify the PivotTable’s source range, extend it if necessary, and refresh. Converting the source range to an Excel table can make later additions easier to include.
The percentages seem unexpected: confirm which filters are active and whether the chart is showing the intended value field. Percentages are calculated from the data currently represented, not automatically from an unfiltered grand total.

Also check the data itself. Duplicate records may inflate sums, inconsistent category spelling can split one apparent category into two, and blank category cells can create an unhelpful blank slice. Correcting these issues in the source is usually better than trying to hide them with chart formatting.

PivotChart versus a regular pie chart

A regular pie chart is based on a fixed cell range. It is a good choice when the data is already summarized and you want a simple chart with direct control over its source cells. A PivotChart is more useful when the summary needs to be grouped, filtered, or refreshed as records change.

The trade-off is that PivotCharts are governed by PivotTable fields and behaviors. Some chart editing choices available to ordinary charts may be restricted or behave differently for PivotCharts. If you need a highly customized pie, you can create a separate summary range from the PivotTable and make a regular chart from that range, but then you must ensure the summary and chart stay in sync.

When to choose another chart

Choose a bar or column chart when you need accurate comparisons across many categories, when labels are long, or when values are close together. People can compare bar lengths more reliably than the angles of similarly sized pie slices. Choose a line chart for trends across ordered dates, and a stacked column chart when the goal is to compare category composition across several periods.

Do not use a pie chart for values that include meaningful negative numbers or for unrelated measures. A pie is designed to communicate positive contributions to a whole; it cannot show a negative contribution in a straightforward, honest way. If the data does not form one clear whole, choose a chart type that matches the question rather than forcing it into a pie.

Frequently Asked Questions

Can you make a pie chart from a PivotTable in Excel?
Yes. Click in the PivotTable, choose PivotTable Analyze > PivotChart, select a Pie chart, and arrange one category field and one numeric value field.

How do I show percentages on an Excel pivot pie chart?
Select the chart, add Data Labels from the Chart Elements (+) button, then right-click a label and choose Format Data Labels. Select the percentage option if it is available for the selected label settings.

Why does my pivot pie chart show counts?
The Values field may be set to Count, or the source values may be stored as text. Check Summarize Values By in the PivotTable and correct the source data type if you expect a sum.

Will a pie PivotChart update when I add data?
It updates after the associated PivotTable is refreshed, provided the new rows are inside its source range. An Excel table is a practical source because it expands as you add rows; you still need to refresh the PivotTable.

Can I filter a pivot pie chart with a slicer?
Yes. Insert a slicer for a field in the associated PivotTable. Selecting slicer buttons filters the connected PivotTable and changes the PivotChart to reflect the remaining data.

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.