Pivot Chart Not Updating? Fix the Source and Refresh

If an Excel PivotChart is not updating, refresh its underlying PivotTable first: select the PivotTable and choose PivotTable Analyze > Refresh, or choose Data > Refresh All. If the new records still do not appear, check whether the PivotTable’s source includes them; expand the source or use an Excel Table, then refresh again.

How a PivotChart gets its data

A PivotChart is connected to a PivotTable, which summarizes data from a source such as a worksheet range, an Excel Table, a database, or a Power Query connection. The chart displays that summary; it does not normally scan the original worksheet independently each time the source changes. This is why editing a source cell may not immediately change the chart.

There are two separate questions to check: has the PivotTable refreshed its stored data, and does its source include the rows or columns you expect? Refreshing updates data within the existing source. It does not necessarily extend a fixed source range to include records added beyond its boundary.

For example, suppose a PivotTable summarizes sales from rows 1 through 101, with headings in row 1 and 100 sales records below. You paste 20 new records into rows 102 through 121. Refreshing can appear to do nothing if the PivotTable still points only to rows 1 through 101. The chart is reflecting the PivotTable correctly; the source definition is the part that needs attention.

Refresh the PivotTable and chart

In Excel for Microsoft 365 on Windows, click a cell in the PivotTable that feeds the chart. On the ribbon, select PivotTable Analyze > Refresh. You can also select Data > Refresh All to update all PivotTables and refreshable workbook connections. A PivotChart connected to the refreshed PivotTable should reflect the updated summary.

After refreshing, check whether the new item appears in the PivotTable’s row or column labels, not just whether the chart looks different. If it appears in the PivotTable but not the chart, inspect the chart’s filters, slicers, and displayed categories. If it does not appear in the PivotTable, investigate the source range, source data, or refresh connection.

Use Refresh when you want to update the selected PivotTable from its current source.
Use Refresh All when the workbook has several PivotTables or connected data sources that should be updated together.
If refresh reports an error, read the message and check the relevant connection, file, credentials, or source structure rather than repeatedly refreshing.

In Excel for Mac, select the PivotTable and use the PivotTable ribbon tab’s Refresh command; ribbon labels and placement can vary by release. Refresh All is available from the Data tab in current desktop versions. Excel for the web supports refreshing many PivotTables, but some connection and data-model features require the desktop app. If a command is unavailable, open the workbook in desktop Excel and check the source there.

Check whether new rows are inside the source

To inspect a PivotTable’s source in Windows, select it and choose PivotTable Analyze > Change Data Source. The dialog shows the source range or table name. If it is a fixed cell range, compare its last row and column with the actual data. Update the range to include all records, confirm the change, and refresh. Avoid selecting unrelated notes or totals as part of the source.

An Excel Table is often more dependable for a regularly growing list. Select the source data, choose Insert > Table, confirm that the data has headers if it does, and build the PivotTable from the table. When you add records within the table or extend it correctly, the table’s name remains the PivotTable source and its size can grow with the data. Still, verify that pasted records became part of the table: a paste just below the visible table does not guarantee that the table expanded in every situation.

Good source data has one header row, a distinct heading for each column, and a consistent type of information in each column. Avoid blank header cells, merged cells in the data area, and subtotal rows mixed into the records. If a new field, such as Region, was added as a new column, make sure the source includes that column; then refresh and look for the field in the PivotTable field list.

Look for filters, slicers, and hidden items

The data can be present in the PivotTable’s source and still be excluded from the displayed result. A report filter, a filter on a row or column label, or a slicer may be limiting the categories. Open the relevant filter and select the new item, or clear the filter to test whether it is the cause. A slicer can control more than one PivotTable, so check its Report Connections or PivotTable Connections settings if the chart and table respond differently.

Also check whether the new records contain blank values or a differently spelled category. “North,” “North ” (with a trailing space), and “NORTH” can be treated as distinct text entries. A blank value may appear as “(blank)” rather than as the category you expected. Correct inconsistent source values, refresh, and then review the PivotTable labels.

Chart settings matter too. A chart may have a chart filter hiding a series or category, or the axis may be showing only a subset. Select the chart and inspect its filter controls where available. Do not assume that a category missing from the picture is missing from the underlying records until you have checked both the PivotTable and its filters.

When formulas or calculated source values change

If the source data contains formulas, first ensure that Excel has recalculated them. In Windows, Formulas > Calculation Options shows the calculation mode; Automatic is the usual setting for workbooks that should recalculate as inputs change. If calculation is Manual, recalculate the workbook and then refresh the PivotTable. Recalculation updates formula results; refresh updates the PivotTable summary. These are separate operations.

A PivotTable may also retain items that no longer exist in the current source, making an old category appear to remain in a filter list. To adjust this behavior, select the PivotTable, open PivotTable Analyze > Options, and look for the Data tab’s “Number of items to retain per field” setting. Choose None if you want old items removed from the retained list, then refresh. The precise dialog layout can vary between Excel releases, and this setting does not add missing new records; the source still has to include them.

If the source includes errors such as #N/A or inconsistent values, determine whether the PivotTable is summarizing or grouping the affected field. Fix the source where possible, recalculate, and refresh. Be cautious about replacing errors with zero: that changes the meaning of the underlying data and can affect sums and averages.

Refresh Power Query, external data, or the Data Model

Some PivotTables are built from Power Query results, an external database, or the Excel Data Model rather than a plain worksheet range. In those cases, refreshing only the PivotTable may not retrieve the latest records from the original system. Use Data > Refresh All to update workbook connections and PivotTables, or refresh the relevant query or connection from the Queries & Connections pane. The order and available options depend on how the workbook is configured.

If the connection cannot update, check that the source file or database is reachable, that credentials have not expired, and that the query still returns the expected columns. A query can refresh successfully yet return no new rows because its source file, date filter, or transformation excludes them. If a PivotTable uses the Data Model, its source may not be editable through Change Data Source in the same way as a range-based PivotTable; update the model’s underlying query or connection instead.

For a workbook shared with other people, confirm that the displayed file is the saved, refreshed copy and not an older download or cached browser preview. If refresh requires access to a company system, someone without the necessary permissions may be unable to retrieve current data even though the PivotChart itself is working normally.

Separate a PivotChart issue from a regular chart

A true PivotChart is linked to a PivotTable and has PivotChart field controls or related PivotChart tools. If you instead made a regular chart from cells that happen to contain PivotTable results, that chart may use a fixed range of cells. It can fail to show new categories when the PivotTable grows, even though the PivotTable refreshed correctly. Select the chart and check its data source; for a regular chart, expand the chart’s source range or base it on a structured Table where appropriate.

Do not rebuild a PivotChart just because it looks unchanged. First verify the PivotTable’s results and the chart filters. If the PivotTable is correct but the chart is not, check that you are looking at the chart linked to that PivotTable and that its displayed fields have not been filtered. If the chart is actually a regular chart, treat its range as a separate issue.

A practical troubleshooting order

Working through checks in a consistent order helps identify the cause without changing unrelated settings:

Confirm the new records are present in the source sheet, query result, or external system.
Check that the records are inside the PivotTable’s source range or Excel Table.
Recalculate formula-driven source values if necessary, then refresh the PivotTable or use Refresh All.
Look for the new category in the PivotTable itself and inspect report filters, slicers, and label filters.
If the PivotTable is right, inspect the chart’s filters and determine whether it is a PivotChart or a regular chart.
If a connection is involved, check refresh status, credentials, query filters, and access to the source.

Keep a copy of the workbook before making substantial changes to a source definition or query. Changing a source range can affect other PivotTables that share the same cache, and changing a query can affect multiple reports. A small, reversible diagnostic change is safer than rebuilding the chart before you know where the update is being lost.

Frequently Asked Questions

Why does my PivotChart not update when I change a cell?
A PivotChart generally reflects a PivotTable summary, which must be refreshed after source values change. Select its PivotTable and choose PivotTable Analyze > Refresh. If the value still does not appear, check whether the source includes the edited cell and whether filters exclude it.

Why are new rows missing after I click Refresh?
The PivotTable may use a fixed range that ends before the new rows. Select the PivotTable, check PivotTable Analyze > Change Data Source, and extend the range or use an Excel Table as the source. Refresh again after correcting the source.

Does Refresh All update every PivotChart?
Refresh All updates refreshable workbook connections and PivotTables, subject to the workbook’s setup and your access to external sources. A PivotChart normally follows its updated PivotTable. A regular chart based on PivotTable cells may still need its chart data range expanded.

Why does the PivotTable update but the chart does not?
Check that the chart is linked to the PivotTable you refreshed, then inspect chart filters, slicers, and hidden categories. If it is a regular chart rather than a PivotChart, its fixed source range may not include newly added PivotTable cells.

Can I make a PivotChart refresh automatically?
Some PivotTable options allow refreshing data when the workbook opens, but this does not guarantee that every external connection will succeed or that a fixed source range will expand. For ongoing updates, use a well-maintained Excel Table or query source, set the appropriate refresh option, and verify the workbook’s connection permissions.

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.