Pivot Table Charts in Excel: Create, Format, and Use

Yes. In Microsoft Excel for Microsoft 365 on Windows, click inside a PivotTable, choose PivotTable Analyze > PivotChart, select a chart type, and click OK. The resulting PivotChart is linked to the PivotTable, so its categories, values, and filters respond to the fields and controls used in that table.

What a PivotChart is

A PivotChart is a chart connected to a PivotTable. It visualizes the summarized data in the table rather than plotting every row of the original source data. For example, a sales list with thousands of transactions can be summarized by month and product category in a PivotTable, then shown as a chart comparing monthly totals. The PivotChart uses the PivotTable’s fields and filters to determine what appears.

That connection is useful when you want to explore data interactively. Filter a region, change the date grouping, or move a field from Rows to Columns, and the chart updates to reflect the new summary. A PivotChart is therefore more than a picture of a PivotTable: it is an alternate, visual view of the same analysis.

There is an important trade-off. A PivotChart is designed to stay connected to its PivotTable, so it does not behave exactly like a regular chart. In particular, changing its field layout can also change the connected PivotTable. If you need a chart that is independent of the PivotTable, a standard chart based on copied summary values may be a better choice.

Create a PivotChart from a PivotTable

Before inserting a chart, make sure the PivotTable has the fields and summary you want to communicate. A chart inherits that structure, so a confusing field layout can produce a confusing visual. To create one in Excel for Microsoft 365 on Windows:

Click a cell inside the PivotTable. The contextual PivotTable tabs appear on the ribbon.
Choose PivotTable Analyze > PivotChart.
In the Insert Chart window, choose a chart category and a specific chart style.
Click OK. Excel inserts the PivotChart, usually on the same worksheet as the PivotTable.
Move or resize the chart as needed, then use the chart design and formatting controls to make it readable.

If you cannot see the PivotChart command, first check that the selected cell is actually inside a PivotTable. Selecting a nearby cell in the worksheet is not enough. The contextual tab may be labeled slightly differently in other Excel editions or languages; on Excel for Mac, select the PivotTable and look for the PivotTable Analyze tab and its chart command. Ribbon arrangement can vary with the version and window size.

How the chart uses PivotTable fields

PivotTable fields become chart components. Fields in the PivotTable’s Rows area commonly provide the chart’s category axis, while fields in Columns often create separate data series. A numeric field in Values supplies the plotted measurements. A field in Filters can limit the entire report to a selected group. Excel may use different labels in the chart field list, such as Axis (Categories) and Legend (Series), but the underlying idea is the same.

For example, imagine a source table with Order Date, Region, Product, and Revenue columns. A PivotTable with Order Date grouped by month in Rows, Product in Columns, and Sum of Revenue in Values can produce a line chart showing monthly revenue trends for each product. Adding Region to Filters lets a reader view one region at a time. If the PivotTable instead places Region in Rows, the chart’s categories change to regions.

Field placement matters as much as chart type. Too many categories can crowd an axis, and too many series can make a legend difficult to interpret. If the chart seems to show an unexpected total, check the Values field’s summary setting: Excel might be counting records rather than summing a numeric field. Open the field’s value settings in the PivotTable and confirm that the calculation matches the question being asked.

Choose a chart type that fits the summary

Pick a chart according to the comparison you want a reader to make, not simply because a style looks appealing. Common choices include:

Column or bar: Compare totals across a manageable number of categories, such as revenue by region or units sold by product.
Line: Show change over an ordered sequence, especially dates grouped by month, quarter, or year.
Pie or doughnut: Show parts of one whole when there are only a few categories and the values form a meaningful total. Many slices make this comparison hard.
Area: Emphasize totals or changes over time, but use care when stacked areas make individual series difficult to compare.

PivotCharts do not offer every chart type available for ordinary Excel charts. For example, scatter, stock, and combination chart types are not available as PivotCharts. If a specialized chart is essential, copy the summarized PivotTable results to a separate range and create a regular chart from that range. The copied chart will not automatically follow PivotTable filters unless you build an additional process to update its source.

Format the chart and control field buttons

After inserting the chart, use the Chart Design and Format tabs to adjust its appearance. Add a descriptive chart title, check that axis labels include useful units, and choose colors that distinguish series without overwhelming the data. A chart showing monthly revenue, for instance, is more informative when the title or axis makes clear whether values are dollars, thousands of dollars, or another measure.

PivotCharts can display field buttons directly on the chart. These buttons let viewers filter or rearrange fields, but they can obscure the data or make a finished presentation look busy. To hide them, select the PivotChart and choose PivotChart Analyze > Field Buttons > Hide All, or use the relevant field-button options to hide only particular button groups. Hiding buttons changes the display, not the underlying PivotTable or its filters.

Keep the PivotTable accessible while building the chart, since the table is often the quickest place to inspect the exact summarized values. For a presentation sheet, you can place the chart and table on separate worksheets or position the table out of the way. Avoid deleting the PivotTable that supports a PivotChart: the chart depends on its PivotTable connection.

Filter a PivotChart with report filters and slicers

A PivotChart responds to filters applied to its associated PivotTable. A report filter can narrow the view to one region or period; the chart then reflects that selection. You can also add a slicer, a visual set of buttons for filtering fields. Select the PivotTable or PivotChart, then use PivotTable Analyze > Insert Slicer, choose the field, and select OK. For date fields, Excel may offer a timeline through PivotTable Analyze > Insert Timeline.

Slicers are useful when a workbook will be explored by people who may not know how to open a filter menu. For instance, a Region slicer can make it easy to switch between North, South, East, and West. If a workbook has multiple PivotTables, a slicer does not necessarily control all of them automatically. Select the slicer, open its report connections or PivotTable connections option, and select the compatible PivotTables it should control. The PivotTables generally need to share the same data source or cache for this connection to work.

Refresh the chart when source data changes

A PivotChart reflects the PivotTable’s current summary, and the PivotTable may need a refresh after source records change. Right-click inside the PivotTable and choose Refresh, or use Data > Refresh All to refresh workbook connections and PivotTables. The chart updates when its connected PivotTable updates.

Refresh does not always expand a PivotTable’s source range to include newly added rows. If the source was a fixed cell range, new records below that range may be left out. A useful preventive step is to format the source data as an Excel Table before creating the PivotTable; tables expand as rows are added, and the PivotTable can then use the table as its source. If records are still missing, inspect the PivotTable’s data source and confirm the new rows are included, then refresh again.

Refreshing can also change the visible chart when categories disappear from the source or when filters remain active. If a chart looks incomplete after a refresh, check both the source range and the PivotTable’s filters. For workbooks connected to external data, refresh behavior can depend on the connection, permissions, and whether the data source is available.

Common problems and practical fixes

The PivotChart button is missing: Click inside the PivotTable, not just somewhere on the worksheet. If the selection is correct, confirm that you are using an Excel edition that supports creating PivotCharts.
The chart shows counts instead of totals: Inspect the Values field’s summary calculation. Text entries in a numeric-looking column can also lead Excel to count records rather than sum values.
New records do not appear: Check whether the PivotTable source includes them. Refreshing alone cannot include rows outside a fixed source range.
The chart changes when you adjust the table: That is expected for a connected PivotChart. Its field layout and filtering are tied to the associated PivotTable.
The chart is difficult to read: Reduce the number of categories or series, filter to a meaningful subset, choose a more appropriate chart type, and clarify titles and units.

Another frequent misunderstanding is that a PivotChart permanently captures the values present when it was created. It does not: it is a view of a PivotTable and can change when the table’s fields, filters, or refreshed source data change. If a fixed snapshot is needed for a report, copy the chart or its values into a separate workbook or create a regular chart from a stable range, while keeping in mind that a pasted picture will not be interactive.

PivotChart or regular chart?

Choose a PivotChart when the purpose is to explore grouped data and let users filter or rearrange the analysis. It is convenient for reports where someone might switch between products, regions, or time periods without building separate charts. Its link to the PivotTable makes updates and interactive filtering straightforward.

Choose a regular chart when you want complete control over a chart’s source range, need a chart type unavailable to PivotCharts, or do not want chart changes tied to PivotTable field changes. A regular chart can be made from a copied summary range, but that range may not update with PivotTable filtering. This is the central decision: PivotCharts favor interactive analysis; regular charts favor independent chart construction and control.

Frequently Asked Questions

Can I create a chart directly from a PivotTable?

Yes. Click inside the PivotTable, choose PivotTable Analyze > PivotChart, select a chart type, and click OK. Excel creates a chart linked to that PivotTable.

Does a PivotChart update when I filter the PivotTable?

Yes. Filtering the associated PivotTable changes the data shown in its PivotChart. Slicers and timelines can also filter the view when connected to that PivotTable.

Can one slicer control more than one PivotChart?

It can control multiple compatible PivotTables, and charts connected to those tables will reflect the filter. Use the slicer’s report or PivotTable connections to select the tables; connection options depend on the PivotTables sharing a suitable source or cache.

Why does my PivotChart change when I rearrange PivotTable fields?

They share the same field layout and summary. Moving a field changes the PivotTable structure and therefore changes the chart’s categories, series, or values. That linked behavior is normal.

Can I make a PivotChart independent of its PivotTable?

Not as a PivotChart: it remains connected to a PivotTable. For an independent chart, copy the summarized values to a separate range and insert a regular chart using that range as its 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.