Excel Pie Chart From PivotTable: How to Create One

Yes—you can create a pie chart directly from an Excel PivotTable by selecting a cell in the table and choosing PivotTable Analyze > PivotChart, then selecting a pie chart. Put one category field in Rows and one numeric measure in Values; the resulting PivotChart stays connected to the PivotTable and responds to its filters.

What a PivotChart pie chart shows

A pie chart divides one total into slices, with each slice representing a category’s share of that total. For example, a PivotTable could summarize sales by product and show each product’s contribution to total sales. The chart is most useful when the categories are parts of the same whole and there are only a few of them.

A PivotChart is not just a normal chart placed beside a PivotTable. It is linked to the PivotTable’s fields and can reflect changes made through PivotTable filters, chart filters, or connected slicers. If you rearrange the fields or change the summarized values, the chart can update to match.

Pie charts are designed for one data series. A clear setup is one field that names the slices and one value field that supplies their sizes. Adding several measures or series can make the chart unsuitable or confusing. If the goal is to compare values across many categories, a bar or column chart is usually easier to read.

Prepare the source data

Before inserting a PivotTable or chart, check the source data. Each column should have a single, nonblank header, and each row should represent one record. Avoid merged cells, subtotal rows, and blank rows inside the data. Use consistent category names, so values such as North and north are not treated as separate labels.

For example, a sales list might have columns named Date, Product, Region, and Sales. To show the proportion of sales by product, summarize Sales and use Product as the category. The PivotTable will add together the sales records for each product, so the chart represents each product’s share of the combined total rather than showing every transaction separately.

If you expect to add records later, turn the source range into an Excel Table first. Select a cell in the data and choose Insert > Table, confirm that the table has headers, and select OK. A PivotTable based on an Excel Table can use the expanded table as its source after new rows are added; you still need to refresh the PivotTable to bring the new records into the summary.

Also check that the measure is numeric and summarized appropriately. A Values field might default to Sum, but Excel can use Count when it encounters text or inconsistent data. In the PivotTable, open the Values field menu, choose Value Field Settings, and confirm the calculation you intend to chart.

Create a pie PivotChart in Excel for Windows

In Microsoft Excel for Microsoft 365 on Windows, use these steps when a PivotTable already exists:

Click any cell inside the PivotTable. This makes the PivotTable-specific ribbon tab available.
Choose PivotTable Analyze > PivotChart. If the PivotTable Analyze tab is not visible, first check that the active cell is inside the PivotTable.
In the Insert Chart dialog, select Pie, choose a style such as 2-D Pie, and select OK.
Move or resize the chart if needed by dragging its border or corners. Keep the PivotTable nearby if readers need to see the underlying totals.
Check that the slices represent the intended categories and that the chart has one sensible measure.

If you have not made a PivotTable yet, select a cell in the source data and choose Insert > PivotTable. In the dialog, confirm the table or range, choose where to place the PivotTable, and select OK. In the PivotTable Fields pane, drag the category field to Rows and the measure to Values. Then select a cell in the completed PivotTable and follow the chart steps above.

Excel for Mac has PivotTables and PivotCharts, but the ribbon layout or tab labels can differ from Windows. Look for the PivotTable-specific Analyze tab and its PivotChart command after selecting the PivotTable. Excel for the web may not expose every PivotChart editing command available in the desktop app; if a command is missing, open the workbook in desktop Excel to create or fully format the chart.

Arrange fields for readable slices

The field layout has a direct effect on the chart. For a product-share chart, Product belongs in Rows and Sales belongs in Values. Leave Columns empty unless you have a specific reason to divide the data into separate series. Fields placed in Filters can limit which records contribute to the total.

Before presenting the chart, consider whether the PivotTable is showing every category. A report filter or a label filter can exclude categories, changing the denominator and therefore changing every displayed percentage. If you filter to one region, for instance, the slices show each product’s share within that region—not its share of all company sales.

Many tiny slices make a pie chart difficult to interpret. You can filter the PivotTable to show a meaningful subset, group categories where appropriate, or choose a bar chart when you need to compare many individual values. If you use a category such as Other, make sure the PivotTable actually includes the categories represented by that slice.

Format labels, percentages, and the legend

Labels help readers understand a pie chart without repeatedly matching colors to a legend. Select the chart, then choose Chart Design > Add Chart Element > Data Labels and select a position. For more control, choose More Data Label Options and use the Format Data Labels pane to select items such as Category Name, Value, and Percentage.

For a compact chart, category name and percentage may be enough. Showing both the value and percentage can be useful when readers need the actual amounts as well as their proportions, but too many labels can overlap. Excel may reposition labels or leave them crowded when slices are small. In that case, make the chart larger, move labels outside the slices, show a legend, or reduce the number of categories.

Use color consistently and avoid relying on color alone to distinguish slices. A meaningful title, such as Sales by Product, explains the measure and category. If the chart is filtered to a particular time period or region, make that context visible in the title, a nearby note, or the report controls. Otherwise, a reader may mistake a filtered share for the overall share.

Refresh and filter the chart

A PivotChart reflects its PivotTable, but it does not necessarily recalculate itself as soon as source records change. After editing or adding source data, click in the PivotTable and choose PivotTable Analyze > Refresh. To refresh PivotTables in the workbook together, use Data > Refresh All. If new rows were added outside the original source range, update the PivotTable source or use an Excel Table as the source so the added rows can be included.

You can filter the report using the PivotTable’s filter controls or the PivotChart’s field buttons. A slicer provides a visible way to filter a field: select the PivotTable, choose PivotTable Analyze > Insert Slicer, select a field, and choose OK. Slicers can make a report easier to use, but check that the chart title or surrounding text makes clear which filter selection is active.

PivotChart field buttons can take up space in a finished report. Select the chart and use the Field Buttons command on the PivotChart Analyze tab to hide them if readers should interact through slicers or other controls instead. Hiding buttons changes the chart display; it does not remove the PivotTable connection.

Common problems and practical fixes

The PivotChart command is missing: Select a cell inside the PivotTable, not a nearby worksheet cell or an ordinary chart. If you are using Excel for the web or a version with a different ribbon layout, open the workbook in the desktop app and look for the PivotTable-specific Analyze tab.
The chart shows counts instead of sales totals: Check the Values field and its Value Field Settings. If Excel chose Count, inspect the source column for numbers stored as text or other nonnumeric entries, correct the source, and refresh.
The percentages do not match expectations: Review report filters, slicers, and excluded categories. A pie chart calculates shares from the data currently represented, so filtering changes the total used for the proportions.
Some slices are missing or look wrong: Check for blanks, zero values, negative values, and inconsistent category names. Pie charts are intended for positive parts of a whole; they do not communicate negative contributions well. Use a bar chart when negative values matter.
The labels overlap: Show fewer labels, enlarge the chart, move labels outside, or use a different chart type. A pie chart with many narrow slices is hard to read even when the data is correct.
The new source rows do not appear: Refresh the PivotTable and verify its source range. If the range did not expand, change the source or convert the source data to an Excel Table for easier expansion in future updates.

PivotChart versus a regular pie chart

Choose a PivotChart when the summary should stay tied to PivotTable fields and respond to PivotTable filtering. It is useful for an interactive report where someone can switch regions, products, or dates without rebuilding the chart. The trade-off is that PivotCharts include PivotTable behavior and field controls that may require extra setup when preparing a polished dashboard.

A regular pie chart is often simpler when the values are final and do not need PivotTable filtering. You can copy a small summary to a separate range and insert a standard pie chart from that range. Unlike a PivotChart, the ordinary chart is not controlled by the PivotTable’s fields. If the summary changes, confirm that the chart’s source range still includes the intended labels and values.

Consider a doughnut chart if you want a similar part-to-whole display with a center space, but it has the same basic limitations as a pie chart: too many categories or very similar values are hard to compare. For precise comparisons, a sorted bar chart is generally clearer because readers can compare lengths against a common scale.

Frequently Asked Questions

Can you make a pie chart from a PivotTable in Excel?
Yes. Select a cell in the PivotTable, choose PivotTable Analyze > PivotChart, and select a pie chart. Use one category field and one numeric value field for a straightforward result.

Does a PivotChart update when I filter the PivotTable?
Yes. A PivotChart is linked to its PivotTable and reflects applicable filters and field changes. If you change the underlying source records, refresh the PivotTable so the chart uses the updated data.

Why does Excel show Count instead of Sum in my pie chart?
Excel may use Count if it does not recognize all entries in the value field as numbers. Check the source data for numbers stored as text or other nonnumeric cells, correct them, refresh, and confirm the Value Field Settings.

Can a pie PivotChart show percentages?
Yes. Add data labels, open More Data Label Options, and select Percentage. You can also select Category Name or Value, but showing too many items can make small slices difficult to read.

Can I make a PivotChart without a PivotTable?
A PivotChart is built from a PivotTable, so create the PivotTable first if your data is not already summarized that way. For a chart that does not need PivotTable controls, make a regular pie chart from a prepared summary range instead.

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.