Excel Pivot Chart Not Updating? Fixes That Work

If an Excel PivotChart is not updating, refresh the PivotTable behind it: select the PivotTable and choose PivotTable Analyze > Refresh, or use Data > Refresh All to update all workbook connections and PivotTables. If new rows still do not appear, check whether the PivotTable’s source range includes them; refreshing cannot add records that are outside its source.

Start with the quickest refresh

A PivotChart is tied to a PivotTable, so refreshing the chart’s underlying PivotTable is the first fix to try. In Excel for Microsoft 365 on Windows:

Click a cell inside the PivotTable that supplies the chart.
On the ribbon, select PivotTable Analyze > Refresh. In some ribbon layouts, the contextual tab may be labeled Analyze.
Wait for the refresh to finish, then check whether the chart changes. If the workbook uses several connections or PivotTables, choose Data > Refresh All instead.

You can also right-click inside the PivotTable and choose Refresh. On Windows, Alt+F5 refreshes the selected PivotTable; Ctrl+Alt+F5 runs Refresh All. If the chart is on another worksheet, the PivotTable still has to be refreshed, even if you cannot see it beside the chart. These commands update data that the PivotTable can access; they do not automatically fix a wrong source range, a failed connection, or a filter that hides the new records.

How a PivotChart gets its data

A regular chart usually refers directly to a worksheet range. A PivotChart instead presents the summarized results of a PivotTable. The PivotTable groups and aggregates records, and the chart reflects those summarized results. Its field buttons and filters are connected to the PivotTable’s fields, so changing a filter or moving a field can change the chart without changing the source data.

This relationship explains a common misunderstanding: editing a value in the source list does not always make the chart change immediately. The PivotTable may be displaying results from its last refresh, and its source may have been defined as a fixed range. Refreshing updates the PivotTable from the source it knows about; it does not necessarily discover a different worksheet, add missing columns, or repair a broken external connection.

PivotTables may also share a PivotTable cache, an internal store of source data used to produce summaries. This can make refresh behavior seem less direct when several PivotTables use related data. The practical check is still to identify the PivotTable connected to the chart and confirm that its source and refresh completed successfully.

Check whether the source range includes new records

If an added row is missing after a successful refresh, inspect the source. Select the PivotTable and choose PivotTable Analyze > Change Data Source. The dialog shows the range or connection it uses. Compare that source with the actual data, including the last row and any newly added columns. If records were pasted below a fixed range, the PivotTable may still be looking only at the original cells.

For example, suppose the source is A1:D100, with headers in row 1, and you add a sale in row 101. Refreshing that PivotTable will not include the new sale if its source remains A1:D100. Update the source to include row 101, then refresh. A better way to avoid repeated range edits is to store the source in an Excel Table:

Select a cell in the source list and choose Insert > Table. Confirm that the table has headers if the first row contains field names.
Use the table as the PivotTable source. When new records are added directly below the table, the table can expand to include them.
Refresh the PivotTable after adding records. Table expansion and PivotTable refresh are separate things; the chart will not necessarily recalculate just because the table grew.

If the field list does not show a newly added column, check that the source includes that column and that its header is present and unique. A blank header or a header row that has been altered can prevent Excel from treating the source as a clean list. For a PivotTable based on the Data Model or an external connection, the Change Data Source control may be unavailable or may not be the right place to change the source; update the underlying model or connection instead.

Refresh queries and connections in the right order

Some PivotCharts use data loaded by Power Query, a database connection, or another workbook connection. In that setup, refreshing only the PivotTable may not fetch the latest records from the original source. Refresh the connection or query first, then allow the PivotTable to update. Data > Refresh All is a useful starting point because it refreshes workbook connections and PivotTables, but a long-running or background query may take time to finish.

To inspect connection activity, open Data > Queries & Connections. Look for an error, a query that is still running, or a connection that points to an old file or location. If a query loads its results to a worksheet table, confirm that the query output has updated before diagnosing the PivotChart. If the query itself still shows old data, investigate its source, credentials, filters, and refresh status rather than changing the chart.

External data can require access to a network, a database, or sign-in credentials. A workbook that worked on another computer may not refresh if the current user lacks permission or the source path is unavailable. The PivotChart cannot display updated data that the connection failed to retrieve, so note any message Excel shows during refresh.

When refresh succeeds but the chart still looks unchanged

A completed refresh does not guarantee that every change will be visually obvious. Check the PivotTable itself first. If its values changed but the chart did not, confirm that the chart is still connected to the PivotTable you refreshed and that its plotted fields are the ones you expect. If neither the table nor chart changed, focus on the source, connection, calculation, or filters.

Check filters and slicers. A report filter, slicer, timeline, or field filter may exclude the new category or records. Clear or adjust filters to see whether the missing data appears.
Check the value field. A PivotTable may summarize a field by count rather than sum, or may be showing a different measure than expected. Review the field arrangement and value-field settings.
Check labels and dates. New date values may not fit an existing grouping as expected. Inspect the grouped date field and, if necessary, adjust or remove the grouping before refreshing again.
Check chart scale and categories. A new value may be too small to notice on the current axis, or a category may be hidden by sorting, filtering, or the chart’s layout. Compare the chart with the PivotTable results.

Also check whether source cells contain formulas. A PivotTable refresh reads the values currently calculated in those cells. If Excel is set to manual calculation, a source formula may still be showing an old result. Choose Formulas > Calculation Options > Automatic, or recalculate the workbook, then refresh the PivotTable. Changing calculation settings can affect the whole workbook, so consider the impact if it contains many formulas.

Set refresh behavior and avoid unnecessary work

If you often open a workbook and find old PivotTable results, select a cell in the PivotTable, open PivotTable Analyze > Options, and look on the Data tab for Refresh data when opening the file. The setting is useful when the source is available and you want the PivotTable to refresh as the workbook opens. It does not repair an incorrect source or guarantee that an unavailable external connection will succeed.

Refresh All can take longer than refreshing one PivotTable, especially in workbooks with multiple queries, external connections, or large data models. Use the selected PivotTable’s Refresh command when you know only that summary needs updating. Use Refresh All when several connected objects may be stale. If the workbook is shared, coordinate edits to the source and avoid assuming that another person’s open copy has already refreshed.

Before changing a source range or rebuilding a PivotTable, make a copy of the workbook if the report is important. A source change can alter field availability, grouping, or the results used by more than one report. Afterward, compare a few totals against the source or an independently checked summary to confirm that the refreshed chart is reporting the intended data.

Excel on Mac and Excel for the web

On Excel for Mac, select the PivotTable and use the contextual PivotTable Analyze tab’s Refresh command, or use Data > Refresh All where available. Ribbon labels and keyboard shortcuts can differ by Mac version and configuration, so the menu command is the most dependable guidance. The underlying checks are the same: refresh the PivotTable, verify its source, and check any query or connection.

Excel for the web also supports working with PivotTables, but available refresh and connection options can vary with the workbook and the data source. If a command is missing or a connection cannot be refreshed in the browser, open the workbook in the desktop Excel app and check the connection there. Avoid assuming that a chart is stale merely because the browser view has not finished updating; confirm the PivotTable’s displayed values first.

Frequently Asked Questions

Why does my Excel PivotChart not update when I change the source data?
PivotCharts display PivotTable results, which may need a refresh. Select the related PivotTable and choose PivotTable Analyze > Refresh. If new rows are still absent, confirm that the PivotTable source includes them.

How do I make a PivotChart include new rows automatically?
Base the PivotTable on an Excel Table rather than a fixed cell range. A table can expand as records are added below it, but you still need to refresh the PivotTable to update its summary and chart.

Does Refresh All update PivotCharts?
Refresh All updates workbook connections and PivotTables. A PivotChart should then reflect its refreshed PivotTable, provided the query succeeds, the source includes the data, and filters do not hide it.

Why does my PivotTable update but the PivotChart does not?
Check that the chart is linked to the PivotTable you refreshed. Then inspect chart fields, filters, slicers, and axis settings. A chart can appear unchanged if a new value is small or its category is filtered out.

Can I set a PivotChart to refresh automatically when I open the file?
The option is set on the PivotTable: select it, open PivotTable Analyze > Options, and look on the Data tab for Refresh data when opening the file. The setting depends on the source being available and refreshable.

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.