Add a Pivot Chart to an Existing PivotTable in Excel

Yes. In Excel for Microsoft 365 on Windows, click a cell inside the existing PivotTable, select PivotTable Analyze > PivotChart, choose a chart type, and select OK. Excel creates a PivotChart connected to that PivotTable, so its fields and filters can be used to explore the same summarized data.

Add the chart step by step

Start by selecting a cell within the PivotTable—not a nearby worksheet cell or the source data. Excel displays the contextual PivotTable ribbon tab when the selection is inside the report. Then follow these steps:

Select PivotTable Analyze > PivotChart. In some ribbon layouts, the command appears in the Tools group on the PivotTable Analyze tab.
In the Insert Chart window, choose a chart category and a specific chart style. A column chart is a useful starting point for comparing categories; a line chart often suits values across dates.
Select OK. The chart is added to the worksheet and remains connected to the PivotTable.
Move or resize the chart as needed. Select its edge and drag it, or use the sizing handles. You can also cut and paste it to another worksheet in the same workbook.

The chart normally appears on the sheet containing the PivotTable. This creates a chart from the existing summary; it does not require rebuilding the PivotTable or selecting the original source records. If the PivotChart command is unavailable, first check that the active cell is inside a recognized PivotTable and that the workbook is editable.

What a PivotChart is connected to

A PivotChart is more than a conventional chart that happens to display PivotTable numbers. It is connected to the PivotTable’s field structure and summarized data. The chart represents fields placed in areas such as Axis (Categories), Legend (Series), Values, and Filters. The exact field names in the pane can vary with the chart and Excel layout.

That connection is useful for analysis: changing a field filter or selecting a category can update the visual and the associated PivotTable view. However, the chart and table are not two entirely independent reports. Adjusting the field arrangement through the PivotChart can change the PivotTable’s layout too. If you need a chart whose categories and series can be rearranged independently, consider making a separate summary or a normal chart instead.

The chart’s visual formatting—such as its colors, title, labels, and size—is generally handled separately from the data layout. A refresh or a change in the PivotTable can still alter what appears in the chart, because the underlying summary has changed.

Choose a chart type that suits the summary

Pick a chart based on the question the PivotTable answers, not just on appearance. For example, a PivotTable with sales by region and product can use a clustered column chart to compare regions, with product categories shown as series. A PivotTable with monthly totals can use a line chart to make the direction of change easier to see.

Column or bar: Compare values across a manageable number of categories. A bar chart can be easier to read when category names are long.
Line: Show a pattern across an ordered sequence such as months or quarters. Make sure the date or period field is arranged in chronological order.
Pie or doughnut: Show parts of one whole when there are only a few meaningful categories. Many slices make the comparison difficult.
Area: Emphasize totals or broad trends over time, especially when the stacked values have a clear meaning.

PivotCharts do not offer every chart type or feature available to ordinary charts. In particular, specialized types such as XY scatter, stock, and bubble charts are not supported as PivotCharts in the same way. If you need one of those, or a combination chart, a regular chart based on a separate summary may be more appropriate. You can change a supported chart type later using Chart Design > Change Chart Type.

Arrange fields and improve readability

To control what the chart shows, select the chart and open the PivotChart Fields pane if it is not already visible. Drag fields between the available areas. For instance, with a sales PivotTable, place Month in Axis (Categories), Product in Legend (Series), and Revenue in Values. The chart then compares revenue by product across the months represented in the PivotTable.

Check the Values area before interpreting the chart. A numeric field may be summarized by Sum, Count, or another calculation depending on the source and field settings. If a chart shows the number of records instead of total revenue, open the value field’s settings in the PivotTable and choose the intended summary. A chart cannot correct an unsuitable summary; it displays the PivotTable’s result.

Keep the chart focused. Too many series can create a crowded legend, and a large number of category labels can become unreadable. Filter the report to a useful subset, shorten or rotate labels where appropriate, and add a descriptive chart title. If the PivotTable uses a date field, grouping the dates into months or quarters can make the axis more useful than plotting every individual date.

Use filters, slicers, and timelines

PivotChart filter buttons let readers filter fields represented in the chart. Depending on the chart, buttons may appear for axis fields, series fields, or report filters. Select a button and choose or clear items to change the displayed selection. These controls relate to the connected PivotTable, so filtering the chart can also affect what is shown in the table.

For a more visible interactive control, select the PivotTable and use PivotTable Analyze > Insert Slicer, then choose the fields for which you want clickable buttons. For a date field, Excel may offer PivotTable Analyze > Insert Timeline. Slicers and timelines can make a report easier to explore than small chart filter buttons, especially when it will be used by people who did not build it.

If a workbook has multiple PivotTables, a slicer does not automatically control all of them. Select the slicer and use Slicer > Report Connections (the tab or command can be named PivotTable Connections in some layouts) to choose compatible PivotTables. The reports generally need to share an appropriate data source or PivotTable cache. If a report is missing from the connection list, verify how it was created rather than assuming the slicer is broken.

Refresh the PivotTable and chart

A PivotChart reflects the PivotTable’s current summarized data. If new rows are added to the source, the chart will not necessarily include them until the PivotTable is refreshed and the source range includes those rows. Select a cell in the PivotTable and use PivotTable Analyze > Refresh. To refresh workbook connections and PivotTables together, use Data > Refresh All.

For source data that grows regularly, an Excel Table is often a practical source because its range expands as rows are added. Convert the source range to a table with Insert > Table before building the PivotTable, or change the PivotTable’s source through PivotTable Analyze > Change Data Source when appropriate. Refreshing updates the PivotTable and its connected PivotChart; it does not repair an incorrect source range or include data that the source does not contain.

Refreshing can also change the chart’s visible categories if source items have been added, removed, or filtered. Review the chart after a refresh, particularly if it is used in a report. If the chart must present a fixed snapshot, copy the relevant summary and create a standard chart from that copy rather than relying on a live PivotChart.

Common problems and how to fix them

PivotChart is disabled: Click inside the PivotTable, confirm it is a real PivotTable rather than a formatted range, and check whether the sheet or workbook is protected. A selection outside the report hides or changes the contextual commands.
The chart shows counts instead of totals: Check the PivotTable’s value field summary. Text-formatted numbers or blank cells in the source can also affect whether Excel can sum a field as expected.
New source rows are missing: Refresh the PivotTable and verify that its data source includes the added rows. A fixed source range may need to be expanded or replaced with an Excel Table.
The chart changes when the table is rearranged: That is expected for a connected PivotChart. Field layout and filtering are tied to the PivotTable; use a separate summary and standard chart if you need independent layouts.
Labels or series are crowded: Filter categories, reduce the number of series, choose a bar chart for long labels, or summarize the data at a higher level such as quarter rather than day.

Also distinguish a chart problem from a data problem. If the PivotTable itself contains an unexpected total, inspect the source values, filters, grouping, and aggregation settings first. Changing colors or chart type will not change the underlying calculation.

PivotChart versus a regular chart

Use a PivotChart when interactive filtering and a direct connection to a PivotTable are valuable. It is a good fit for an exploratory report where a reader may want to switch regions, products, or dates without editing the source data. Its main trade-off is that chart structure is constrained by the PivotTable and by the chart types supported for PivotCharts.

A regular chart is a better fit when you need a highly customized combination, a specialized chart type, or chart series independent of the PivotTable layout. One approach is to create a separate summary range with the exact labels and values required, then select that range and use Insert > Insert Column or Bar Chart or another chart command. The summary must be updated when the PivotTable changes unless it is built with a method that updates automatically. Avoid treating a PivotChart as a static picture: its connection is precisely what makes it respond to PivotTable changes.

Excel for Mac and Excel for the web

The steps above use Excel for Microsoft 365 on Windows. In Excel for Mac, select a cell in the PivotTable and look for the PivotTable Analyze tab and its PivotChart command; ribbon organization and command availability can differ between Mac releases. If the command is not visible, use the Excel desktop app with a current Microsoft 365 update and check that the workbook is editable.

Excel for the web can display and interact with many PivotTables and charts, but creation and editing options can differ from the desktop app and from workbook to workbook. If you cannot create or fully configure the chart in the browser, open the workbook in the desktop version of Excel. In all versions, preserve a copy before making substantial changes to a shared report.

Frequently Asked Questions

Can I add a PivotChart without creating a new PivotTable?
Yes. Select the existing PivotTable and choose PivotTable Analyze > PivotChart. Excel uses that report as the chart’s data source rather than asking you to build a separate summary from scratch.

Will filtering the PivotChart also filter the PivotTable?
Usually, yes. A PivotChart is connected to its PivotTable, and field selections and filters are linked. This shared behavior is useful for interactive analysis but may be inconvenient if you want the table and chart to show different selections.

Can I put the PivotChart on another worksheet?
Yes. After creating it, cut and paste the chart onto another worksheet in the same workbook, or move it by dragging. The chart remains connected to the PivotTable, so keep that source report available and avoid deleting it.

Can I change a PivotChart into a normal chart?
There is not a simple conversion that preserves all PivotChart behavior while making the chart independent. Create a separate summary range from the data you want to show, then insert a regular chart from that range if independent series or unsupported chart types are required.

Why does my chart not update after I add data?
The PivotTable may need a refresh, or its source range may not include the new rows. Use PivotTable Analyze > Refresh, then check PivotTable Analyze > Change Data Source if the added records remain outside the source.

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.