Excel Pivot Table Chart Maker: Create PivotCharts

To make a chart from an Excel PivotTable in Microsoft 365 for Windows, click inside the PivotTable and choose PivotTable Analyze > PivotChart, select a chart type, and click OK. If you have only a source-data list, create a PivotTable first with Insert > PivotTable; Excel’s chart linked to that summary is called a PivotChart.

What an Excel PivotChart does

A PivotChart is a chart connected to a PivotTable. It visualizes the fields and calculations in that table, so changing the PivotTable’s arrangement, filters, or summarized values can change the chart too. For example, a sales PivotTable grouped by month and product can become a chart showing monthly sales, with a separate series for each product.

The key difference from an ordinary chart is that a PivotChart works with PivotTable fields. It includes controls for categories, series, filters, and values, and those controls reflect the PivotTable’s structure. You can filter the view without rebuilding a chart range by hand. A PivotChart is especially useful when the source list is long or when readers need to explore the same figures by different categories.

It is not a separate chart-making app or a one-click way to turn any data into a polished dashboard. You still choose which fields to summarize, select a chart type that suits the comparison, and format the result so the main pattern is clear.

Prepare the source data

Before making a PivotTable or PivotChart, check that the source is arranged as a clean rectangular list. Each column should have one distinct heading, and each row should represent one record, such as one order line or one monthly observation. Avoid merged cells, blank header cells, and subtotal rows within the data. Those features can make fields confusing or interfere with refreshes.

For example, a sales list might have columns named Date, Region, Product, Units, and Sales. Each order line gets its own row. Do not put a total row between records or use the same heading for two different columns. If dates are stored as text, Excel may not group them as dates in the PivotTable; convert them to genuine Excel dates first.

Converting the list to an Excel Table is helpful because a Table expands when you add records, and a PivotTable based on it can use the expanded source after refresh. Select a cell in the data and choose Insert > Table, confirm the range, and check that the table has headers. This is optional, but it makes a growing dataset easier to manage. A PivotTable does not necessarily update just because a new source row has been entered.

Create a PivotTable and PivotChart

For a predictable setup, create the summary first, check that it answers the question you have, and then insert its chart:

Click a cell in the source list or Excel Table. Choose Insert > PivotTable.
In the dialog, verify the table or range. Choose New Worksheet or a location on an existing worksheet, then select OK.
In the PivotTable Fields pane, drag fields into Rows, Columns, Values, or Filters. For a sales-by-region example, put Region in Rows and Sales in Values.
Click a cell in the resulting PivotTable. Choose PivotTable Analyze > PivotChart.
Select a chart category and style in the Insert Chart dialog, then click OK. Move or resize the chart as needed.

Some Excel builds also offer a PivotChart command on the Insert tab that lets you choose a source and create the summary and chart as part of the same workflow. The PivotTable-first route is useful because you can inspect the aggregation and field layout before deciding how to visualize them. On Excel for Mac, the ribbon organization and tab names can differ slightly by release; select the PivotTable and look for its PivotChart command on the contextual PivotTable tab. Excel for the web has a different interface and may not expose every desktop chart or PivotTable option.

Arrange fields to answer a useful question

The chart is only as meaningful as its field arrangement. A field in Rows usually supplies categories along the chart’s horizontal axis; a field in Columns can create separate series; and a numeric field in Values supplies the plotted measurements. A field in Filters applies a report-wide filter. The exact display depends on the chart type and layout.

Suppose the question is whether product sales rise or fall over time. Put Date in Rows and Sales in Values, then group the dates by month or quarter if the data and Excel’s grouping options allow it. Put Product in Columns to compare products as separate series. If there are dozens of products, the chart may become crowded; filter to a few products or make separate views instead.

Check how Excel summarizes values. A numeric field is often summarized by Sum, but Excel may choose Count when it treats the field as text or when the data is unsuitable for summing. In the Values area, open the field’s menu and choose Value Field Settings to select an appropriate calculation such as Sum, Count, or Average. Average sales per order and total sales answer different questions, so do not treat them as interchangeable.

Choose a chart type that fits the comparison

Use a column or bar chart to compare amounts across a modest number of categories. A line chart is usually better for showing a trend across ordered dates. A stacked chart can show how parts contribute to a total, but it becomes difficult to compare individual series when there are many categories. A pie chart is most legible with a small number of parts that add up to a meaningful whole; it is not a good way to compare many products or track changes over time.

Excel supports many chart types for PivotCharts, but not every chart type is available. In particular, PivotCharts do not support XY (Scatter), Stock, or Bubble chart types. If you need one of those, or need a specialized combination of chart behaviors, consider building a regular chart from a separate summary range instead. Availability and some formatting controls can vary by Excel version.

Keep the chart’s message narrow. If the goal is to show monthly totals, a clear date axis and one or a few series are more useful than displaying every available field. Give the chart a descriptive title, check that the value axis uses sensible units, and avoid adding decoration that competes with the data.

Filter, refresh, and interact with the chart

PivotChart field buttons let a viewer filter or rearrange fields from the chart itself. You can also use the associated PivotTable’s filters. To add a visual filter control, click the PivotTable and choose PivotTable Analyze > Insert Slicer, select a field, and click OK. For date fields, Excel may offer a timeline control through PivotTable Analyze > Insert Timeline. Slicers and timelines can make a report easier to explore, but they do not replace a clear chart title or explanation of what is being filtered.

When source records change, refresh the PivotTable so the summary and chart use the updated data. Click in the PivotTable and choose PivotTable Analyze > Refresh, or use Data > Refresh All to refresh workbook connections and other refreshable data. If you add rows outside the original source range, first confirm that the PivotTable’s source includes them. An Excel Table source is often easier to extend, but you still need to refresh the PivotTable.

To reduce clutter, select the chart and use PivotChart Analyze > Field Buttons to hide some or all field buttons. The exact button options can vary with the selected chart and Excel build. Hiding them changes the chart’s appearance; it does not convert the PivotChart into a regular chart or remove its connection to the PivotTable.

Common problems and practical fixes

The chart shows counts instead of totals: Check the Values field’s summary setting. If Excel is counting a supposed numeric field, look for text values, blanks, or inconsistent entries in the source column.
New records do not appear: Refresh the PivotTable and check its source range. If new rows sit beyond a fixed range, update the source or use an Excel Table as the source for future additions.
Dates appear as individual entries or cannot be grouped: Check that every source value is a real date and that the date column has no blanks or text mixed in. Then refresh and try grouping the date field in the PivotTable.
The chart is difficult to read: Reduce the number of series, filter to relevant categories, or choose a different chart type. A chart with many colored lines or tiny pie slices rarely becomes useful through formatting alone.
The desired chart type is unavailable: The chart may be unsupported for PivotCharts. Create a compact summary range and insert a standard chart from that range when you need a scatter, stock, or bubble chart.

PivotChart versus a regular Excel chart

Choose a PivotChart when the data is best explored through PivotTable fields, categories, and filters. Its main advantage is that it stays connected to the PivotTable’s analysis. Reorganizing or filtering that summary can update the visualization without manually selecting a new source range.

Choose a regular chart when you want precise control over a fixed range, need a chart type unavailable to PivotCharts, or want to plot a specially prepared helper table. A regular chart can use a summary produced by a PivotTable, but its source range and behavior are managed separately. If the summary changes size, you may need to adjust the chart’s data range. In short, a PivotChart is convenient for interactive analysis; a regular chart can be more flexible for a deliberately designed presentation.

Frequently Asked Questions

Can I make a chart directly from an existing PivotTable?
Yes. Click inside the PivotTable, choose PivotTable Analyze > PivotChart, select a chart type, and click OK. The new chart is associated with that PivotTable.

Does a PivotChart update automatically when I change the source data?
Not usually just because a source cell changed. Refresh the PivotTable with PivotTable Analyze > Refresh or Data > Refresh All. Also make sure the PivotTable source includes any newly added rows.

Can I use a slicer with a PivotChart?
Yes. Insert a slicer from the associated PivotTable using PivotTable Analyze > Insert Slicer. Select a field and use the slicer buttons to filter the PivotTable and its connected chart.

Why does my PivotChart show Count instead of Sum?
Excel may be treating the source values as text, or the Values field may be set to Count. Inspect the source column for text-formatted numbers or inconsistent entries, then use Value Field Settings to select Sum if summing is appropriate.

Can I make a scatter plot from a PivotTable?
Not as a PivotChart: XY (Scatter) is among the unsupported PivotChart types. You can make a separate summary range from the PivotTable’s results and create a standard scatter chart from that range.

Is a PivotChart the same as a chart made from PivotTable cells?
No. A PivotChart is linked to the PivotTable and uses its fields and filtering behavior. A standard chart can plot cells that happen to contain PivotTable results, but it is managed as a regular chart and may need its range adjusted as the summary changes.

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.