Excel PivotCharts: How to Create and Use Them

To make an Excel chart from a PivotTable, click inside the PivotTable, choose PivotTable Analyze > PivotChart, select a chart type, and click OK. Excel creates a PivotChart linked to the PivotTable, so changing or filtering the summarized data updates the chart too.

What an Excel PivotChart Does

A PivotChart visualizes the summarized results of a PivotTable. Instead of plotting every row in a large source list, it displays categories and values that the PivotTable has grouped or calculated. For example, a sales PivotTable can total revenue by month and product; its PivotChart can show monthly totals as columns, with product names as separate series.

The chart and PivotTable are connected. Filtering a product in the PivotTable changes the chart, and using a chart field button to filter the chart changes the PivotTable view. This connection is useful for exploring data, but it also means a PivotChart is not simply a normal chart whose source range happens to contain summarized numbers. Its fields and filters are controlled by the associated PivotTable.

Use a PivotChart when people need to explore categories or filter a report interactively. If the chart should be a fixed graphic with no PivotTable controls, or you need a chart type that PivotCharts do not support, a regular chart may be a better choice.

Create a PivotChart from a PivotTable

These steps apply to Excel for Microsoft 365 on Windows. Start with a PivotTable that already summarizes the data you want to show.

Click any cell inside the PivotTable. Excel displays the contextual PivotTable tabs on the ribbon.
Choose PivotTable Analyze > PivotChart.
In the Insert Chart window, choose a chart category and a specific design. A clustered column chart is a reasonable starting point for comparing amounts across categories; a line chart often suits values tracked over time.
Click OK. Excel inserts a PivotChart linked to the PivotTable.
Move or resize the chart, then review its title, axes, legend, and displayed fields.

For a useful starting layout, imagine a source table with Date, Region, Product, and Revenue columns. In a PivotTable, put Date in Rows, Product in Columns, and Revenue in Values, summarized by Sum. The chart will then compare revenue by product across the date categories. If Excel groups the dates automatically, check that the grouping matches the reporting period you need.

The exact chart you get depends on the PivotTable layout. A field in Rows typically supplies category labels, a field in Columns can create series, and a numeric field in Values supplies plotted values. Moving a field between these areas changes the chart’s organization. If the PivotTable has several value fields or categories, simplify its layout before inserting a chart so the result is readable.

Choose a Chart Type That Fits the Question

Pick a chart based on the comparison you want readers to make, not just on appearance. A chart that works for a few categories can become confusing when the PivotTable contains dozens.

Clustered column or bar: Compare values across a manageable number of categories, such as revenue by region. Bars are often easier to read when category names are long.
Line: Show how a measure changes over ordered time periods, such as monthly orders. A separate line for every product may become crowded, so consider filtering to a few products.
Stacked column or bar: Show both category totals and their composition, such as each region’s sales split by product. Comparing individual segments is harder when they do not share a common baseline.
Pie or doughnut: Show parts of a whole when there are only a few categories and the values form a meaningful total. Many slices make the comparison difficult.

Some chart types, including XY (scatter) charts, are not available as PivotCharts. If you need one of those types, or need a specialized chart layout, copy the summarized results and build a regular chart from that separate range. A copied-value chart will not respond to PivotTable filters unless you provide another way to update its source.

Filter the Chart with Field Buttons and Slicers

PivotCharts may show field buttons on the chart. These buttons let a reader filter or rearrange fields without returning to the PivotTable. Their labels and available controls depend on the fields in the report. If the buttons clutter a presentation, select the chart and use the PivotChart Analyze tab’s Field Buttons control to hide them. Hiding the buttons changes what is displayed, not the chart’s connection to the PivotTable.

For a more visible report control, add a slicer. Select the PivotTable, then choose PivotTable Analyze > Insert Slicer, select fields such as Region or Product, and click OK. Selecting a slicer button filters the connected PivotTable and PivotChart. To clear a slicer selection, use its clear-filter control.

If the data includes dates, a timeline can provide a date-range filter. Select the PivotTable and choose PivotTable Analyze > Insert Timeline, then select a date field. Slicers and timelines are especially useful on dashboards because readers can see which filters are available instead of opening small drop-down menus.

One slicer can control more than one PivotTable when those PivotTables share a compatible data source or PivotTable cache. Select the slicer and use Slicer > Report Connections (the tab appears when the slicer is selected) to choose which PivotTables it controls. If a PivotTable is missing from the list, it may not share the required connection; matching field names alone do not guarantee that two PivotTables can share a slicer.

Keep the Chart Current When Source Data Changes

A PivotChart reflects its PivotTable, and a PivotTable generally needs to be refreshed to bring in changes from its source. To refresh one report, right-click inside its PivotTable and choose Refresh, or select PivotTable Analyze > Refresh. To refresh PivotTables in the workbook together, use Data > Refresh All.

Adding rows below a fixed source range may leave new records outside the PivotTable’s source. A practical safeguard is to convert the source list into an Excel table before creating the PivotTable: select a cell in the data and choose Insert > Table, confirming whether the table has headers. When a PivotTable uses that table as its source, added table rows can be included when you refresh. Refreshing is still necessary; it is not the same as recalculating a worksheet formula.

Refresh timing matters in shared reports. A chart can look out of date simply because someone changed the source data but did not refresh the PivotTable. If a workbook must open with current results, check the PivotTable connection or options for refreshing data when the file opens, and verify the behavior with the workbook’s actual data source. External connections can have their own permissions and refresh requirements.

Format and Arrange a PivotChart

After insertion, use the chart’s contextual ribbon tabs to adjust its presentation. Depending on the chart and Excel build, the ribbon includes controls for chart elements, styles, colors, and data selection. You can also select the chart title and type a clearer description, such as “Monthly Revenue by Product,” rather than leaving a generic title.

Useful formatting choices include:

Use an axis title or number format when readers need to know whether values are dollars, units, or percentages.
Keep a legend when colors distinguish multiple series, but remove it when there is only one series and it adds no information.
Use consistent colors for the same products or regions across related charts.
Reduce unnecessary gridlines and avoid three-dimensional effects that make values harder to compare.

A PivotChart can be moved and resized like other embedded charts. To place it on its own chart sheet, select the chart and use Chart Design > Move Chart, then choose a new sheet. The chart remains linked to its PivotTable. If you move or hide the PivotTable, make sure the report still has the filters and context users need.

On Excel for Mac, PivotCharts and PivotTables are available, but ribbon layout and some controls can differ from Windows. Look for the PivotTable or PivotChart contextual tabs after selecting the relevant object; names and placement may vary by release. Excel for the web can display many workbook charts and PivotTables, but authoring and editing options may differ from the Windows desktop app, so use the desktop app if a required command is unavailable.

PivotChart or Regular Chart?

Choose a PivotChart if the chart should follow PivotTable grouping, filters, and field changes. It is a good fit for an interactive analysis report in which someone might switch from one region to another or compare different products without rebuilding the chart.

Choose a regular chart if you need a chart type unavailable to PivotCharts, want precise control over a fixed set of cells, or need to plot a custom arrangement that does not map well to PivotTable fields. One approach is to copy the PivotTable results and paste values into a separate range, then create a regular chart from that range. That creates a snapshot: refreshing the PivotTable will not automatically rewrite the pasted values or update the regular chart.

There is no requirement to put a PivotChart next to its PivotTable, but keeping them together can make the report easier to understand and maintain. If the PivotTable is hidden on another sheet, leave clear labels or instructions so users know what filters affect the chart.

Common Problems and How to Fix Them

The chart shows the wrong totals: Check the PivotTable’s Values area and its summary method. A numeric field may be summarized by Count instead of Sum, especially if Excel interprets some source entries as text. Also confirm that filters have not excluded records.
New records are missing: Refresh the PivotTable and confirm that its source includes the new rows. If the source is a fixed cell range, update the source or use an Excel table as the source for future additions.
The chart is crowded: Remove unnecessary fields, filter to fewer categories, or use a bar chart for long labels. A PivotChart faithfully reflects the PivotTable layout, so the clearest fix may be simplifying the table.
Dates appear as individual days instead of months: Check the date field and its grouping in the PivotTable. Invalid or text-formatted dates can prevent sensible date grouping; correct the source values and refresh.
A slicer will not control another chart: Check its Report Connections and whether the second PivotTable uses a compatible shared source or cache.
The chart disappears or becomes blank after filtering: Clear the chart’s filters and inspect the PivotTable for blank fields or a filter combination with no matching records.

Frequently Asked Questions

Can I create a chart directly from a PivotTable?
Yes. Click inside the PivotTable and choose PivotTable Analyze > PivotChart. Select a chart type and confirm. Excel creates a chart connected to the PivotTable.

Does a PivotChart update automatically when I change the source data?
Not necessarily. Refresh the PivotTable using PivotTable Analyze > Refresh or Data > Refresh All. Also confirm that the PivotTable’s source includes any newly added rows.

Can I make a PivotChart without showing its PivotTable?
You can place the chart separately or hide the sheet containing the PivotTable, but the PivotChart remains connected to that PivotTable. Keep the underlying report available to the workbook and consider how users will access its filters.

Can one slicer filter several PivotCharts?
Yes, if their associated PivotTables can share the slicer, usually because they share a compatible source or cache. Select the slicer, open Slicer > Report Connections, and select the PivotTables to connect.

Why can’t I choose a scatter chart for my PivotChart?
XY (scatter) charts are not supported as PivotCharts. Copy the summarized data to a separate range and create a regular scatter chart from that range if you need numeric x- and y-values.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

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

Spotted an error in this guide? Let us know.