
You change a number, and the chart stays exactly as it was. You add a new row of sales, and the chart ignores it. When excel charts not updating leaves your chart showing last week’s numbers, the chart itself is rarely broken — usually the link between the chart and the data has a small fault in it.
The good news is that most causes are easy to check. A chart can point at a fixed range that no longer covers new data, wait on a calculation setting that is turned off, hide data behind filters or hidden rows, or hold values that were typed in by hand instead of linked to cells. This guide works through those causes in order, from the simplest check to the deeper fixes. Nothing here deletes your data, and every fix can be tested without changing the original chart.
Table of Contents
- Why This Error Happens
- Quick Checks
- Diagnosing the Problem
- Fix 1: Turn Automatic Calculation Back On
- Fix 2: Check the Chart Data Range Includes the New Data
- Fix 3: Convert the Range to an Excel Table
- Fix 4: Show Hidden Rows and Columns in the Chart
- Fix 5: Refresh External Data and PivotTable Sources
- Fix 6: Check the Chart Points to the Right Sheet and Workbook
- Fix 7: Replace Hardcoded Values with Cell References
- Fix 8: Clear Filters That Hide the Chart Data
- Fix 9: Force a Full Recalculation and Rebuild the Chart
- Fix 10: Test the Chart in a New Workbook
- Fix 11: Update Excel and Repair the Office Installation
- What to Avoid
- Frequently Asked Questions
- Conclusion
- Helpful Official Resources
Why This Error Happens
A chart is a picture of a range of cells. Excel redraws that picture whenever the cells change, but only if three things are true: the chart points at the right cells, Excel recalculates the workbook, and the cells are visible to the chart. If any one of those fails, the chart freezes. These are the reasons that happens most often.
1. Calculation Is Set to Manual
Excel only redraws charts when it recalculates the workbook. If Calculation Options is set to Manual, perhaps after working with a large file, Excel stops recalculating on its own. Your values change, but the chart is never told, so it keeps showing the old picture. This is the most common cause of excel charts not updating, and it can appear suddenly, because the setting is shared across all open workbooks in the same Excel session.
2. The Chart Range Does Not Cover the New Data
A chart built from a fixed range, such as A1:B12, only watches those cells. New rows typed below row 12 fall outside the range, and the chart ignores them. The chart is not broken — it is faithfully showing exactly the range it was told to show. Any data added outside that range is invisible to the chart until the range is extended.
3. Hidden Rows, Columns, or Filters Hide the Data
By default, Excel charts do not plot hidden rows and columns. If you hide a row, filter it out, or collapse a grouped outline, the chart drops those points. The data is still there, and the chart range still covers it, but the chart treats hidden cells as if they were empty. A filter left on from earlier work can quietly remove half the chart.
4. The Chart Holds Hardcoded Values
A chart series can hold numbers typed directly into the chart, instead of references to cells. When that happens, the chart has no link to the worksheet at all, so changing a cell cannot change the chart. Hardcoded values creep in when a chart is pasted from another program, copied as a picture, or built by typing numbers into the series formula by hand.
5. The Data Comes from an External Source That Has Not Refreshed
Charts fed by external data — a database query, a web query, or another workbook — only update when that data refreshes. If the query is set to refresh by hand, or the source workbook is closed, the chart shows the last refreshed values. A chart linked to a PivotTable has the same behaviour: the chart updates only when the PivotTable itself refreshes.
6. The Chart Is Linked to the Wrong Sheet or a Broken Link
A chart copied from another workbook can keep pointing at the old file. If that file moved, was renamed, or is closed, the chart cannot reach its data, and it shows stale values. Links also break when a sheet is renamed, because the chart still looks for the old sheet name. In both cases the chart looks normal, but its data source is a dead end, so excel charts not updating persists until the link is repaired.
Quick Checks
Two minutes before the deep fixes.
- Change one value the chart should show and press Enter — does the chart move at all?
- Check the Formulas tab and look at Calculation Options — is it set to Automatic?
- Click the chart and look at the coloured range outlines on the sheet — do they cover all the data, including new rows?
- Check for hidden rows or columns inside the data range, and for a filter arrow showing an active filter.
- Click the chart and check the formula bar — does the series refer to cells, or to numbers typed in directly?
- Think about when it started — did excel charts not updating begin after adding rows, hiding data, or moving the file?
Diagnosing the Problem
| Symptom | Cause | Go to Fix |
|---|---|---|
| Chart ignores all value changes | Calculation set to Manual | Fix 1 |
| Chart ignores new rows only | Chart range too small | Fix 2 |
| New rows never appear in the chart | Range is fixed, not a table | Fix 3 |
| Chart drops some points | Hidden rows or columns | Fix 4 |
| Chart shows old external data | Source has not refreshed | Fix 5 |
| Chart shows data from another file | Chart points at the wrong workbook | Fix 6 |
| Chart never changes whatever you edit | Hardcoded series values | Fix 7 |
| Chart drops filtered-out rows | Active filter hides the data | Fix 8 |
Fix 1: Turn Automatic Calculation Back On
Start with calculation, because it is the simplest cause and it freezes every chart in every open workbook at once. If calculation is off, no other fix will make the chart move.

- Go to the Formulas tab and click Calculation Options.
- If Manual is selected, click Automatic instead.
- Press F9 to force a full recalculation of the workbook right away.
- Change a value that the chart should show and watch whether the chart moves.
- If the chart moves now, the setting was the cause — leave it on Automatic.
- Remember that the setting is shared: another open workbook can switch it back to Manual.
- Save the file after changing the setting so the workbook keeps the correct mode.
Manual calculation is often switched on for very large workbooks, where recalculating on every keystroke is slow. The trouble is that it stays on after the large workbook closes, and it quietly affects every other file you open. That is why a chart can stop updating in a file you did not change — a different file changed the shared setting. If you must keep Manual on for a heavy workbook, press F9 after editing values to refresh the charts, or use Shift+F9 for the current sheet only. For most workbooks, Automatic is the right setting. If calculation is already Automatic and the chart still ignores new values, the chart range is the next suspect, and Fix 2 shows how to read it.
Fix 2: Check the Chart Data Range Includes the New Data
A chart only shows the range it was built from. If your data has grown past that range, the chart will keep showing the old picture, no matter how many new rows you add.
- Click the chart once to select it.
- Look at the sheet — Excel outlines the chart data range with coloured borders.
- Check whether the outlines cover all the data, including the newest rows and columns.
- If new data falls outside the outlines, right-click the chart and choose Select Data.
- In the Chart data range box, select the full range, including the new rows, with the mouse.
- Click OK and check whether the chart now shows the new data.
- Add one more test row and confirm the chart still ignores it — that tells you the range is fixed and Fix 3 will help.
The coloured outlines are the honest answer to the question “what is this chart showing?” Trust them over your memory of what range you selected when the chart was made. Ranges shrink and grow in surprising ways: deleting a row inside the range shrinks it, inserting a row at the very bottom can leave the new row outside it, and copying a chart can carry a range from the old sheet. When you re-select the range, drag from the first cell to the last in one motion, including the header row if the chart uses headers. If the chart updates after the fix but ignores the next new row again, the range needs to grow on its own, and Fix 3 converts it to a table that does exactly that.
Fix 3: Convert the Range to an Excel Table
An Excel Table grows automatically when you add rows, and a chart built from a table grows with it. Converting the data range to a table is the lasting fix for charts that keep ignoring new data.
- Click any cell inside the data range the chart uses.
- Go to the Insert tab and click Table, then confirm the range and whether it has headers.
- Click the chart, right-click it, and choose Select Data.
- Re-select the chart data range so it points at the table range.
- Add a new row of data directly below the table and watch the table expand to include it.
- Check whether the chart now shows the new row without any further changes.
- If the chart still ignores the new row, delete the chart and rebuild it from the table range.
Tables bring other benefits too: filters, banded rows, and structured references that keep formulas readable. But the key benefit here is automatic growth. When you type in the row directly below a table, Excel extends the table, and anything linked to the table — including charts — sees the new row at once. The one habit to keep is adding new data directly below the table, with no blank row in between, because a blank row breaks the growth. If your data has blank rows by design, fill them or move the data, because blank rows also confuse chart ranges. A chart built from a table is the most reliable setup for data that grows over time. If the chart still drops points after converting, hidden rows or columns may be the cause, and Fix 4 checks that. For tables that feed pivot summaries, our guide to Excel pivot table not refreshing covers the refresh side.
Fix 4: Show Hidden Rows and Columns in the Chart
By default, Excel charts skip hidden rows and columns. A row you hid for tidiness, or a column you collapsed, vanishes from the chart as well — and a chart that drops points looks like excel charts not updating when the data behind it is fine.
- Click the chart, then right-click it and choose Select Data.
- Click Hidden and Empty Cells at the bottom left of the dialog box.
- Tick Show data in hidden rows and columns and click OK.
- Click OK again to close Select Data, and check whether the missing points return.
- If they return, decide whether to keep the setting on, or to unhide the rows instead.
- To unhide rows, select the rows above and below the hidden ones, right-click, and choose Unhide.
- To unhide columns, select the columns on either side of the hidden ones, right-click, and choose Unhide.
The Show data in hidden rows and columns setting is stored with the chart, so it survives saving and reopening. It is a good choice when you hide rows for presentation but still want the chart to show the full picture. It is a poor choice when you hide rows because the data is wrong or incomplete — in that case, fix or remove the data instead of hiding it. Grouped outlines cause the same effect: collapsing a group hides the rows, and the chart drops them. If your chart changes every time you collapse or expand a group, the hidden-data setting is the cause. Filters are a related case with their own fix, covered in Fix 8. If hidden data is not the cause, the chart may be waiting on an external refresh, which Fix 5 covers.
Fix 5: Refresh External Data and PivotTable Sources
Charts fed by external data or by a PivotTable only update when their source refreshes. The chart itself may be fine — it is simply waiting for new data that has not arrived yet.

- Click inside the data range or the PivotTable that feeds the chart.
- Go to the Data tab and click Refresh All to refresh every external connection in the workbook.
- Wait for the refresh to finish, then check whether the chart shows the new values.
- For a PivotTable, right-click it and choose Refresh, then check the chart again.
- Check the connection settings: on the Data tab, click Queries and Connections, right-click the connection, and choose Properties.
- If Refresh is set to manual only, consider enabling refresh when the file opens, if the source is reliable.
- If the refresh fails, check that the source file or database is reachable, and that you have permission to read it.
External refresh failures are often silent. Excel may show the old values with no warning, or it may show a brief message that is easy to miss. After clicking Refresh All, watch the status bar for progress and for any error message, and check the Queries and Connections pane for a failed connection. A PivotTable that feeds a chart needs its own refresh, and the chart will not move until the PivotTable moves — refreshing the chart alone does nothing. If the source is another workbook, that workbook must be open or reachable on the same path; a moved or renamed source breaks the link, which Fix 6 repairs. Do not set every connection to refresh on open if the sources are slow or unreliable — a slow refresh on open makes every file opening feel broken. Refresh by hand when you need fresh data, and keep automatic refresh for sources you trust.
Fix 6: Check the Chart Points to the Right Sheet and Workbook
A chart copied from another file can keep pointing at the old workbook. If that workbook moved, was renamed, or is closed, the chart cannot reach its data, and it shows whatever values it last read.
- Click the chart, then click one data series so the series formula appears in the formula bar.
- Read the formula: it should name the current workbook and sheet, such as
=SERIES(Sheet1!$B$1,Sheet1!$A$2:$A$12,Sheet1!$B$2:$B$12,1). - If the formula names a different workbook in square brackets, the chart is linked to another file.
- Go to the Data tab and click Edit Links to see every external link in the workbook.
- For each link, check the Status and the source path — a missing file shows as an error or an outdated path.
- Use Change Source to point the link at the correct file, or Break Link if the data now lives in this workbook.
- After fixing the link, change a value and confirm the chart updates.
Renaming a sheet breaks chart links in the same quiet way. Excel usually updates references when you rename a sheet, but charts copied between files, or built with older tools, can keep the old name. If the series formula names a sheet that no longer exists, re-select the data range with Select Data to rebuild the reference. Break Link deserves care: it turns linked values into fixed values, which stops updates entirely. Only break a link when the data genuinely lives in the current workbook now. If the chart points at the right sheet and the right workbook but still ignores changes, the series may hold hardcoded numbers instead of references, and Fix 7 checks that. For files that will not open at all, our guide to Excel file not opening covers that problem.
Fix 7: Replace Hardcoded Values with Cell References
A series that holds numbers typed directly into the chart has no link to the worksheet. Changing a cell cannot change the chart, because the chart never looks at the cells. This is a common result of pasting a chart from another program.

- Click the chart, then click one data series to show its formula in the formula bar.
- If the formula contains numbers in curly brackets, such as
{10,50,150}, the values are hardcoded. - Right-click the chart and choose Select Data.
- Select the series and click Edit, then re-select the series values from the worksheet cells with the mouse.
- Repeat for every series in the chart, and for the category labels if they are also hardcoded.
- Click OK and change a value to confirm the chart now follows the cells.
- If re-selecting is awkward, delete the chart and rebuild it from the cell range — a fresh chart always links to cells.
Hardcoded values also appear when a chart is copied from a web page or a presentation and pasted as an Excel chart object. The chart looks like an Excel chart, but its data lives inside the chart object, not on the sheet. The formula bar test is the reliable way to tell: cell references mean a live link, and curly-bracket numbers mean fixed values. Rebuilding the chart is often faster than repairing every series by hand, especially for charts with many series. Keep the old chart on the sheet while you build the new one, so you can copy its title, colours, and axis settings. Once the new chart follows the cells, delete the old one. If the series already refer to cells but the chart still drops rows, a filter is the likely cause, and Fix 8 clears it.
Fix 8: Clear Filters That Hide the Chart Data
Filters hide rows, and hidden rows are skipped by charts. A filter left on from earlier work can quietly remove data from the chart, and the chart will look stale even though the underlying values are current.
- Click inside the data range and look at the header row for filter arrows with a funnel symbol.
- Go to the Data tab and click Clear in the Sort and Filter group to remove all filters.
- Check whether the chart now shows the missing points.
- If the points return, the filter was the cause — decide whether the filter or the full chart matters more.
- If you need the filter, enable Show data in hidden rows and columns from Fix 4 so the chart ignores the filter.
- Check for filters on other sheets that feed the chart, not just the sheet you are looking at.
- Check for AutoFilter arrows on a table that feeds the chart, and clear them the same way.
Filters are easy to forget because they sit quietly in the header row. A funnel symbol on a filter arrow means that column is filtered, and any row it hides is also hidden from the chart. The Clear button removes filters from the whole range at once, which is the fastest test. If clearing filters fixes the chart, you have a choice: keep the data unfiltered, or keep the filter and tell the chart to show hidden data. The second option is usually better for reports, because the reader sees the full chart while you keep the filter for your own work. Note that PivotTable filters behave differently — they change the PivotTable itself, so the chart follows the filtered PivotTable even with hidden data shown. For PivotTable charts, clear the PivotTable filter instead. If filters are clear and the chart still ignores changes, force a full recalculation and rebuild, which Fix 9 covers. For dropdowns that misbehave, our guide to Excel filter dropdown not working covers that fix.
Fix 9: Force a Full Recalculation and Rebuild the Chart
When the settings look right but the chart still will not move, a full recalculation and a fresh chart remove every hidden fault at once. Rebuilding is the honest test: a new chart from the same data either works, which proves the old chart was damaged, or it fails the same way, which proves the data or the settings are at fault.
- Press Ctrl+Alt+F9 to force a full recalculation of every formula in every open workbook.
- Change a value and check whether the chart moves after the full recalculation.
- If it still does not move, select the chart and copy it, then paste it onto a blank sheet as a backup.
- Delete the original chart from the sheet.
- Select the data range, go to the Insert tab, and insert the same chart type again.
- Format the new chart to match the old one: title, axis titles, colours, and legend position.
- Change a value and add a new row to confirm the new chart follows the data.
Ctrl+Alt+F9 is stronger than F9: it recalculates every formula, including ones Excel thinks are unchanged. It is the right tool when a chart or a formula result looks stale for no clear reason. Rebuilding the chart is stronger still, because it removes any damage in the chart object itself — a corrupt chart definition, a broken series, or a setting buried in the chart that no dialog box shows. Keep the copied backup until the new chart is tested, so you can recover the old formatting if needed. If the rebuilt chart works, the old chart object was the fault, and you can delete the backup. If the rebuilt chart fails the same way, the data or the workbook is the fault, and Fix 10 isolates it in a new file.
Fix 10: Test the Chart in a New Workbook
Testing in a fresh workbook separates a broken chart from a broken file. If the same data and chart work in a new file, the original workbook carries the fault. If they fail in a new file too, the data or the chart setup is wrong.

- Press Ctrl+N to open a new blank workbook.
- Type a few test values in columns A and B, such as months and sales figures.
- Select the values and insert a column chart from the Insert tab.
- Change a value and confirm the new chart updates at once.
- Now copy your real data into the new workbook with Paste Special and Values, and rebuild the chart from it.
- If the rebuilt chart works, the original file is damaged — move your data into the new file and keep working there.
- If the rebuilt chart fails too, the data itself is the fault: check for text values, errors, or blank rows with the checks in Fixes 4 and 8.
A new-workbook test also catches add-in interference. Add-ins that change calculation or charting can freeze charts in specific files, and a fresh workbook behaves differently. To test for add-ins, close Excel, then reopen it in Safe Mode by holding Ctrl while Excel starts, and test the chart there. If the chart works in Safe Mode, disable add-ins one at a time from File, then Options, then Add-ins, until the chart works normally. Do not download so-called Excel repair tools from unknown websites — they cannot fix a chart and often carry unwanted software. If the chart fails even in a new workbook in Safe Mode, the installation itself needs attention, and Fix 11 covers that. For formula errors that break chart data, our guide to Excel spill error fix covers that problem.
Fix 11: Update Excel and Repair the Office Installation
If charts fail in every workbook, including new ones in Safe Mode, the Excel installation may be damaged or out of date. Updating and repairing Office fixes broken program files without touching your workbooks.
- Open Excel, go to File, then Account, and click Update Options, then Update Now.
- Wait for the update to finish, restart Excel, and test a chart in a new workbook.
- If charts still fail, close all Office apps completely.
- Open Settings in Windows, go to Apps, then Installed apps, and find Microsoft 365 or Microsoft Office.
- Click the three dots, choose Modify, and select Quick Repair, then follow the prompts.
- Restart the computer after the repair and test a chart again in a new workbook.
- If Quick Repair does not help, repeat the steps and choose Online Repair, which downloads fresh program files and takes longer.
Online Repair needs an internet connection and can take a while, so run it when you do not need Excel for an hour. It reinstalls the Office program files but keeps your documents, settings, and activation. Before either repair, save and close every open workbook, and make a copy of any file you cannot afford to lose — repairs are safe, but a copy costs nothing. After the repair, test with the simple chart from Fix 10 before rebuilding complex charts. If excel charts not updating survives an update and an Online Repair, the fault is almost certainly in the specific workbook, not in Excel: rebuild the workbook by copying values into a fresh file, as described in Fix 10, and rebuild the charts from tables. Contact Microsoft Support through the official help pages linked below if the problem follows you into every new file even after a repair.
What to Avoid
- Do not keep adding rows below a fixed chart range and expect the chart to grow — convert the range to a table instead.
- Do not leave calculation on Manual after finishing a large workbook — it freezes charts in every open file.
- Do not paste a chart from another program and assume it is linked — check the series formula for hardcoded values.
- Do not hide rows or leave filters on and blame the chart — charts skip hidden data by default.
- Do not break external links without thinking — breaking a link turns live values into fixed ones.
- Do not download Excel repair tools from unknown websites — they cannot fix charts and often carry unwanted software.
- Do not rebuild a complex chart before testing a simple one in a new workbook — the simple test saves hours.
Frequently Asked Questions
Why does the chart update for some values but not for new rows?
Because the chart range covers the old rows but not the new ones. New rows typed below a fixed range fall outside the chart. Extend the range with Select Data, or convert the range to an Excel Table so it grows on its own. Fixes 2 and 3 cover both approaches.
Why does the chart go blank when I filter the data?
Because charts skip hidden rows by default, and filtering hides rows. Enable Show data in hidden rows and columns in the Select Data dialog box, or clear the filter. Fixes 4 and 8 explain both options and when to use each.
Can a chart update from a closed workbook?
It can show the last values it read, but it cannot fetch new values from a closed file until the link refreshes. Open the source workbook, or use Edit Links to update the link, and check that the source path is still correct. Fix 6 walks through link repair.
Why does the chart update on one computer but not on another?
The usual cause is a different calculation setting, a missing add-in, or a broken link path that exists on one computer but not the other. Check Calculation Options first, then Edit Links, then test in Safe Mode. Fixes 1, 6, and 10 cover those checks in order.
Do charts update when the data comes from formulas?
Yes, as long as calculation is Automatic and the formulas recalculate. If a formula returns an error, the chart may skip that point or show a gap. Fix the formula error first, then press F9 and check the chart. Fix 9 covers forced recalculation.
Should I rebuild the chart or fix the old one?
Fix the old one first if the fault is a setting, a range, or a filter — those take a minute. Rebuild when the chart object itself seems damaged, when the series hold hardcoded values, or when several fixes have failed. Fix 9 explains how to rebuild safely while keeping a backup.
Conclusion
When excel charts not updating leaves your chart showing old numbers, the fix is almost always the calculation setting, the chart range, or hidden data — not a broken Excel. Turn Automatic calculation back on first, then check the coloured range outlines, then convert the range to a table so it grows with your data. Finish with a simple test: change one value and add one new row, and watch the chart follow both. That visible movement is the proof that counts. Set the range, test the value, and let the chart tell the current story.

[…] charts in the same workbook also show stale or wrong values, our guide to Excel charts not updating covers the chart side of stale […]
[…] built on text values misbehave too, showing gaps or wrong scales, and our guide to Excel Charts Not Updating covers chart faults that share this […]