Excel Update Pivot Chart: Steps and Fixes

To update an Excel PivotChart in Microsoft 365 for Windows, click its associated PivotTable and choose PivotTable Analyze > Refresh, or select Data > Refresh All to refresh every PivotTable and connected data source in the workbook. The chart updates from its PivotTable; if new rows do not appear, refresh the PivotTable and check whether its source range includes those rows.

How a PivotChart gets its data

A PivotChart is linked to a PivotTable, which summarizes the underlying records into categories and values. For example, a sales table with Date, Region, and Amount columns could be summarized by month and region, then displayed as a column chart. The chart reflects the summary—not each original record directly—so refreshing the PivotTable is usually the key step when the chart looks out of date.

This link also explains a common misconception: changing the chart’s appearance does not refresh its source data. You can change its chart type, colors, titles, and displayed fields, but the records and summary are controlled by the PivotTable and its data source. Likewise, refreshing the PivotTable updates the chart’s values and categories, but does not necessarily preserve every visual choice if the refreshed data changes the chart’s structure.

Refresh one PivotChart or the whole workbook

To refresh just one PivotChart, refresh its associated PivotTable. You can click a cell in the PivotTable and use PivotTable Analyze > Refresh, or right-click a cell in the PivotTable and choose Refresh. The chart should recalculate from the updated summary. If you are unsure which PivotTable controls a chart, select the chart and look for its associated PivotTable, or use the chart’s field controls to identify the fields in use.

To update all workbook data at once, select Data > Refresh All. This can refresh multiple PivotTables and external or query-based connections, so it may take longer than refreshing a single table. If a workbook connects to a large database or several files, allow the refresh to finish before deciding the chart is still stale. A refresh may also prompt for credentials or report a connection error.

One PivotChart: Refresh its associated PivotTable using PivotTable Analyze > Refresh.
All workbook connections and PivotTables: Use Data > Refresh All.
Windows shortcuts: Alt+F5 refreshes the selected PivotTable; Ctrl+Alt+F5 refreshes all data in the workbook.
Mac: Use the Refresh commands on the ribbon or right-click menu; keyboard shortcuts can differ by keyboard and Excel version.

Make sure new rows are in the source

Refreshing only updates the data that the PivotTable is configured to use. If new records were added below a fixed source range, a refresh might succeed while leaving those records out. Click inside the PivotTable and choose PivotTable Analyze > Change Data Source to inspect or adjust the range. Select the full data range, including the new rows, and confirm the change before refreshing again. The command is available when working with a PivotTable; it may not be the right way to change the source for a PivotTable built from an external connection or the Data Model.

A useful preventive measure is to format the source records as an Excel Table. Select a cell in the records and choose Insert > Table, or press Ctrl+T on Windows. When you add rows immediately below a Table, Excel generally expands the Table to include them. A PivotTable based on that Table can then use the expanded source after you refresh it. Check the Table’s name and the PivotTable source if new rows remain missing; expansion and refresh are separate steps.

When the source is a Power Query result, database connection, or another external source, refresh that source as well as the PivotTable. Data > Refresh All is often the simplest approach, because it updates workbook connections before the PivotTable uses their results. If an external source is unavailable, requires a password, or has changed its columns, the refresh may fail or return incomplete data. Resolve the connection issue first, then refresh and check the chart.

Update fields, filters, and chart layout

Refreshing updates the existing PivotTable layout; it does not automatically choose a new analysis for you. To change what the PivotChart displays, select it and open the PivotChart Fields pane if it is not visible. Drag fields between the Axis (Categories), Legend (Series), Values, and Filters areas. For example, moving Region from Legend to Filters changes the chart from separate regional series to a region-filtered view. The PivotTable and chart remain linked as you rearrange fields.

PivotChart field buttons and PivotTable filters can also limit what appears. A chart that appears unchanged may simply be filtered to one month, product, or region. Check the chart’s field buttons, the PivotTable filters, and any connected slicers or timelines. Clear or adjust the relevant selection to show the desired categories. A slicer connected to several PivotTables can control multiple charts, but only if those PivotTables share a compatible source and the slicer is connected to them.

Refreshing can add categories or series that were not present before. Excel may change the visible axis range or the number of chart elements as a result. If the data is correct but the chart looks different, inspect the field layout, filters, and chart formatting before rebuilding the chart. If you need to change the visual style, select the chart and use the Chart Design and Format tabs; these affect presentation rather than the underlying source records.

Set a PivotTable to refresh when the file opens

If the workbook should use current source data each time it opens, you can enable a refresh-on-open setting for its PivotTable. Right-click inside the PivotTable, choose PivotTable Options, open the Data tab, and select Refresh data when opening the file. The option is useful for a workbook whose source remains accessible, but it can increase opening time or trigger connection prompts. It does not guarantee a successful update if the source is unavailable, the user lacks access, or the connection needs new credentials.

Excel for Mac and Excel for the web may present PivotTable commands differently from Microsoft 365 for Windows, and available management features can vary. Look for the PivotTable refresh command in the ribbon or context menu. For tasks such as changing a complex external source or troubleshooting connection settings, the Windows desktop steps above are the clearest reference; check that the workbook’s source is supported in the version you are using.

Common reasons a chart still looks wrong

If refresh completes but the chart does not show the expected result, check the issue in this order. This helps distinguish a stale summary from a source-range problem or a display setting:

New records are outside the source: Use PivotTable Analyze > Change Data Source, or confirm that the source Excel Table expanded.
The connection did not refresh: Check for a prompt, error, expired sign-in, unavailable file, or failed query. Try Data > Refresh All and read any status or error message.
A filter hides the records: Review PivotTable filters, chart field buttons, slicers, and timelines.
The field layout is not what you expect: Inspect the PivotChart Fields pane and confirm the fields are in the intended areas.
Source values are inconsistent: Check for blank cells, text in a numeric column, inconsistent date formats, or renamed column headers. These can affect grouping and summaries.
The summary is right but the picture is confusing: Review the chart type, axis settings, and series formatting. A different scale or chart type can make correct values look unexpectedly large or small.

For a concrete example, suppose a PivotChart shows monthly sales through June, and you append July records to a worksheet. If the source is an Excel Table, first confirm the new rows are inside it, then refresh the PivotTable. If the source is a fixed range ending in June, change the source to include July before refreshing. If July is included in the PivotTable but not visible in the chart, inspect date filters and the chart’s axis categories. These are three different causes that can produce the same initial symptom.

PivotChart versus a regular chart

A regular chart usually points to a cell range and is often a better fit when you want a fixed presentation with direct control over individual series. A PivotChart is designed to explore summarized data interactively: it can be filtered and rearranged through PivotTable fields, slicers, and related controls. Its close link to a PivotTable is convenient, but it also means the chart’s data structure is governed by the PivotTable rather than ordinary chart ranges.

Use a PivotChart when viewers need to change categories or compare subsets of a larger dataset. Use a regular chart when the plotted range should stay fixed or when you need chart behavior that PivotCharts do not support in the way you want. You can create a regular chart from a PivotTable’s displayed cells, but it will not have the same PivotChart field controls and may not automatically adapt to a different PivotTable layout. Choose based on whether interactive summarizing or precise chart control matters more.

Frequently Asked Questions

How do I update a PivotChart in Excel?
Click its associated PivotTable and choose PivotTable Analyze > Refresh. The chart updates from the refreshed summary. Use Data > Refresh All if the workbook has several PivotTables or connected data sources to update.

Why is my PivotChart not showing new rows?
Refresh does not necessarily expand a fixed source range. Check PivotTable Analyze > Change Data Source and make sure the new rows are included. If the source is an Excel Table, verify that the Table expanded to include them, then refresh.

Can I refresh a PivotChart without refreshing its PivotTable?
No separate chart-data refresh is normally needed. A PivotChart displays its associated PivotTable’s summary, so refresh that PivotTable to update the chart’s values and categories.

What is the shortcut to refresh a PivotTable?
In Excel for Windows, Alt+F5 refreshes the selected PivotTable. Ctrl+Alt+F5 refreshes all data in the workbook. On Mac, use the ribbon or right-click Refresh command because the available shortcut may differ.

Will Refresh All update external data too?
Refresh All attempts to refresh workbook data connections as well as PivotTables. It cannot update a source that is inaccessible or that requires credentials you have not provided, and errors may need to be resolved before the chart can show current results.

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.