Excel Chart Not Updating? How to Fix It

When an Excel chart is not updating, the chart itself is rarely broken. It is showing exactly the cells it points to, and those cells either don't include your new data or haven't changed yet. The usual causes are a source range that stops too early, calculation set to Manual, a pivot chart that needs a refresh, numbers stored as text and hidden rows. This guide shows how to spot each one and fix it for good.

Why is my Excel chart not updating?#

Start with what you changed and what the chart did. This table matches the symptom to the likely cause:

To see what a chart is reading, click it. Excel outlines its source cells on the sheet with coloured borders: one colour for the labels, another for the values.

Fix 1: New rows are outside the chart's data range#

A chart only plots the cells in its source range. If the range is A1:B7 and you add July in row 8, July is ignored. This is the most common cause.

Quick fix: click the chart, then drag the corner of the coloured outline on the sheet down to include the new rows. Or choose Chart Design > Select Data and edit the range.

Lasting fix: turn the data into an Excel table. Click any cell in the data and press Ctrl+T (Mac: ⌘T), then make the chart from the table, or keep the existing chart if it already covers the full table. A table grows when you type in the row just below it, and a chart built on the table's columns grows with it. The guide to Excel tables and Ctrl+T explains how tables expand, and how to make a line chart covers charts that gain a new point every month.

A chart built on a dynamic array formula, such as a UNIQUE list, doesn't grow on its own when the spill gets longer. Point the series at a defined name that uses the spill reference, such as =Sheet1!$F$2#, or put the summary in a fixed range that's big enough.

Fix 2: Calculation is set to Manual#

If your chart is built on formulas and nothing changes when you edit the inputs, Excel may not be recalculating. Go to Formulas > Calculation Options and choose Automatic. To recalculate right away, press F9.

The calculation mode applies to everything open in Excel and is taken from the first workbook you open, so a file saved in Manual mode can switch it on without you noticing. When it's on, formulas show old results until you recalculate, and the chart shows them too. The full list of reasons formulas stop recalculating is in Excel formula not updating.

Fix 3: A pivot chart needs a refresh#

A pivot chart always shows its pivot table, and a pivot table doesn't recalculate when the source data changes. You have to refresh it:

• Right-click the pivot table (Control-click on a Mac) and choose Refresh.
• Or use PivotTable Analyze > Refresh, or Data > Refresh All for every pivot in the file.
• On Windows, Alt+F5 refreshes the selected pivot and Ctrl+Alt+F5 refreshes all.

If new rows still don't appear after a refresh, the pivot's source range is too short; base it on a table instead. The guide to refreshing a pivot table covers refresh on open and changing the data source.

If the chart must always be live, build the summary with formulas instead: a UNIQUE list of categories with SUMIFS beside it. Formulas recalculate on their own, so a chart built on them never needs a refresh.

Fix 4: Numbers stored as text are plotted as zero#

Cells that look like numbers but are stored as text are plotted as zero in column and line charts. They also drop out of totals, which is often the first clue. Here is a small example:

=SUM(B2:B7) returns 1,990 instead of 2,950, because SUM skips the two text values. To count them:

=COUNTA(B2:B7)-COUNT(B2:B7)

COUNTA counts every filled cell (6) and COUNT counts only real numbers (4), so the result is 2. Text numbers are often left-aligned and may show a small green triangle in the corner.

To fix them, select the cells, click the warning icon and choose Convert to Number. Or use a helper column with =VALUE(B3), then paste the results back as values. The chart updates as soon as the cells hold real numbers.

Fix 5: Hidden or filtered rows are left out#

By default, a chart doesn't plot data in hidden rows and columns, and rows hidden by a filter count as hidden. If points disappear when you filter or hide rows, that is why. To keep them:

1. Click the chart and choose Chart Design > Select Data.
2. Click Hidden and Empty Cells.
3. Tick Show data in hidden rows and columns.

The same dialog controls how empty cells are drawn: as gaps, as zero, or with the line connected across them. Sometimes you want the default, because it lets one chart follow a filter.

Other reasons a chart looks stuck#

If none of the fixes above apply, check these:

• The axis bounds are fixed. If someone typed a maximum in Format Axis, values above it are cut off. Click Reset next to Minimum and Maximum to return them to Auto.
• The chart is a picture. A chart pasted as an image never updates. Delete it and copy the real chart again.
• The chart links to another workbook. A chart copied from another file may still read that file. Use Data > Edit Links (called Workbook Links in newer versions) to update or change the source.
• The series holds typed values. Click a series and look at the formula bar. If you see numbers in curly braces instead of cell references, the link to the cells was broken. Re-select the data in Select Data.

For choosing and formatting charts in the first place, see the guide to making a chart in Excel.

Practise it#

Most charts that don't update come down to their data: a range that misses a row, or numbers stored as text. Practise debugging SUM in a live spreadsheet: you find a short range, text numbers and a total that counts itself, and each fix is checked instantly. Then build an always-live summary in the pivot-style summary with formulas lesson, the kind of table a chart can follow without a refresh.