If an Excel graph is not updating when its data changes, first check that the chart points to the cells you edited and that Excel has recalculated any formulas in those cells. In Microsoft 365 for Windows, select the chart and use Chart Design > Select Data to inspect its source; then check Formulas > Calculation Options and choose Automatic if calculation is set to Manual.
Start with the type of change
A chart can appear stale for several different reasons, and the quickest fix depends on what changed. Editing a value already inside the chart’s source range should normally update the plotted result as soon as Excel calculates the cell. Adding a new row, refreshing imported data, changing a filter, or editing a formula that has not recalculated involves a different step.
Use this quick check to narrow it down:
- Changed an existing value: inspect calculation mode and confirm the chart uses that cell.
- Added rows or columns: check whether the source range expanded to include them.
- Updated data from a query or another workbook: refresh the connection or confirm linked values are current.
- Changed a PivotTable: refresh the PivotTable that feeds the PivotChart.
- Expected a hidden or filtered value to appear: review the chart’s treatment of hidden data and filters.
These checks distinguish an actual failure to update from a chart that is updating correctly but still refers to an older or narrower set of data.
How an Excel chart gets its data
A chart is connected to a source range in the workbook. That range supplies the categories, series names, and values used to draw the graph. For example, a chart might use months in A2:A13 as category labels and sales in B2:B13 as one series. Changing a value in B6 should affect the chart if B6 is included in the series. Typing a new value in B14 will not necessarily add a new month if the chart still refers only to rows 2 through 13.
To inspect the connection, select the chart, then choose Chart Design > Select Data. The Chart data range box shows the overall source, while the Legend Entries (Series) and Horizontal (Category) Axis Labels areas let you inspect or edit the series and category references. Select a series and choose Edit to see its name and values. Be careful not to replace a valid range with a partial one while editing.
Excel updates a chart when the data within its source changes; it does not infer every possible intention from nearby cells. A fixed reference such as a range ending at row 13 remains fixed when you type into row 14. This is why changing an existing observation and appending a new observation can produce different results, even in the same worksheet.
Check calculation mode and formula results
If chart source cells contain formulas, the chart plots their calculated results, not the newest inputs you intended the formulas to use. When calculation is set to Manual, a formula result can remain unchanged until you request calculation. This can make both the worksheet and its chart look out of date.
In Excel for Microsoft 365 on Windows, choose Formulas > Calculation Options > Automatic. If Automatic is already selected, press F9 to calculate open workbooks. For a full recalculation of all formulas in all open workbooks, press Ctrl+Alt+F9. These shortcuts recalculate formulas; they do not expand a chart’s source range or refresh a database connection.
On a Mac, use Formulas > Calculation Options to check the calculation setting. Function-key behavior can depend on the Mac’s keyboard settings, so use the Formulas ribbon when a shortcut does not behave as expected. Excel for the web has fewer calculation controls than the desktop app; open the workbook in the desktop version if you need to inspect calculation settings that are unavailable in the browser.
Also check whether the formula itself is producing the new result. If its inputs are unchanged, a reference points to the wrong cells, or a formula returns a blank or an error, recalculating will not create the value the chart needs. Select the source cell and inspect the formula bar before changing chart settings.
Fix a chart that does not include new rows
When new records are entered below the chart’s current source, open Chart Design > Select Data and check the chart data range. If the new row is outside the referenced range, extend the range or edit the relevant series values and category labels. Make sure both the new value and its matching label are included. Expanding only the values can leave the graph with a missing or mismatched category.
For data that grows regularly, format the source as an Excel table. Select a cell in the data and choose Home > Format as Table, then confirm the range and whether it has headers. A chart created from a table can generally include rows added to that table as the table expands. Enter the next record directly in the row below the table, or use Tab from the final cell in the table, and verify that Excel has actually extended the table before relying on the chart to include it.
Tables are helpful for continuously growing lists, but they do not solve every chart-range issue. A chart originally built from a separate fixed range may still refer to that range rather than the table. After converting data, inspect Select Data and confirm the chart uses the intended source. If a workbook has irregular blocks, blank spacer rows, or several unrelated series, a table may not be the right shape for the chart.
Look for filters, hidden rows, and empty cells
Worksheet filters can hide records, and a chart may omit data in hidden rows or columns depending on its settings. Select the chart and open Chart Design > Select Data, then choose Hidden and Empty Cells. If appropriate for the chart, enable the option to show data in hidden rows and columns. The exact options shown can vary with the chart and Excel version.
Also clear or adjust worksheet filters to see whether the missing record is simply filtered out. In a PivotChart, filtering is often controlled by the PivotTable or chart field buttons, so changing the worksheet’s ordinary filter may not affect it. Empty source cells can create gaps or different-looking lines; in the Hidden and Empty Cells dialog, check whether empty cells are shown as gaps, zeroes, or connected data, and choose the representation that matches what the blank means.
Do not replace genuine missing observations with zero automatically. A zero says the measured value was zero; a blank says there is no plotted value. That distinction can materially change the visual story, especially in line charts.
Refresh PivotCharts and imported data
A PivotChart is tied to a PivotTable, so changing the underlying source data does not always update the chart immediately. Select a cell in the PivotTable and choose PivotTable Analyze > Refresh, or use Data > Refresh All to refresh workbook connections and supported queries. In some Excel builds, the PivotTable Analyze tab may have a slightly different label, but it appears when the PivotTable is selected.
If the source data has gained rows, refreshing alone may not include those rows unless the PivotTable’s source range includes them. Select the PivotTable and use PivotTable Analyze > Change Data Source to review the source. A PivotTable built from an Excel table is usually easier to maintain as records are appended, because the table can expand. After refreshing, check that the PivotTable itself displays the new records before troubleshooting the chart.
For Power Query or other external data, a chart may be correctly displaying the last data loaded into the worksheet while the connection has not yet fetched the latest source. Choose Data > Refresh All and wait for the refresh to finish. If the data still looks old, check the query’s source, credentials, refresh errors, and destination range. An external workbook link has a separate dependency: the linked workbook may be closed, moved, or not updated. Review Data > Workbook Links when that command is available, and confirm the link points to the intended file.
Check whether the chart is updating but looks unchanged
Sometimes the chart has refreshed, but the visual change is difficult to see. A very large value can flatten smaller values against the axis, or the vertical axis may use bounds that make a change look minor. Select the axis and open Format Axis to inspect its bounds and scale. Returning the bounds to automatic can help when a fixed minimum or maximum is no longer suitable, but changing an axis can also alter how differences appear, so use a scale that represents the data honestly.
Confirm that you edited the series actually displayed. A chart can contain several series, and a value may belong to a different series or be excluded from the selected chart type. In Select Data, compare each series name and values range with the worksheet. For a line chart, for instance, a new category may be present but not obvious if its value matches nearby points or the line is obscured by another series.
Finally, check that you are viewing the workbook you edited and that the chart is not a picture pasted from another file. A chart object responds to its linked source; a static image does not. Click the object and look for chart-specific tabs such as Chart Design. If those tabs do not appear, you may have selected an image rather than an editable chart.
A practical troubleshooting order
For a reliable diagnosis, work from the source outward rather than rebuilding the graph first:
- Select a source cell that should have changed and confirm its displayed value or formula result.
- Set calculation to Automatic and recalculate if the source depends on formulas.
- Select the chart and inspect its data range, series, and category labels.
- If the data is filtered or hidden, check the filter and Hidden and Empty Cells settings.
- For a PivotChart or imported source, refresh the PivotTable or connection and confirm the worksheet data changed.
- If the chart is still wrong, check axis settings, chart type, and whether the selected object is an actual chart.
Rebuilding should be a last resort. A new chart can reproduce the same problem if it is made from the same incomplete range or stale PivotTable. Once the cause is clear, correct the source or refresh process and then confirm that a later edit behaves as expected.
Frequently Asked Questions
Why does my Excel chart not update when I change a cell?
Check that the edited cell is inside the chart’s source range and that formulas have recalculated. Also confirm you are editing the workbook that contains the chart, not a separate copy.
How do I make an Excel chart include new rows automatically?
Use an Excel table as the chart’s source when the data grows by adding records. Confirm the table expands when you add a row and that the chart is actually connected to the table; a chart based on a fixed range may need its source extended.
Does pressing F9 refresh an Excel chart?
F9 recalculates formulas in open workbooks, which can update a chart that plots formula results. It does not refresh every external data connection, refresh a PivotTable, or enlarge a fixed chart range.
Why is my PivotChart not showing new data?
Refresh its PivotTable and check that the PivotTable’s source includes the new records. If the PivotTable remains unchanged after refresh, inspect its source range or query before changing the chart.
Why does my chart omit filtered or hidden data?
Excel charts can omit hidden rows and columns depending on their settings. Review the worksheet filters and, under Chart Design > Select Data > Hidden and Empty Cells, choose whether hidden data should be shown.
Related
- Data Validation Reference Table in Excel
- Remove Duplicates in Power Query: A Practical Guide
- Power Query Basics: Import, Clean, and Transform Data
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Create an Organizational Chart in Google SheetsTo create an organizational chart in Google Sheets, put each person or position in the first column and…
- How to Insert a Treemap Chart in Excel: Step by StepTo insert a Treemap chart in Excel, arrange your data in columns from broad category to specific item,…
- Excel Pivot Chart: How to Change the Data Source SafelyTo change an Excel PivotChart’s data source, select its associated PivotTable, choose PivotTable Analyze > Change Data Source,…
- Excel Dashboard Software Tutorial: Build One Step by StepTo build an Excel dashboard, organize your source data in a clean Excel Table, summarize it with PivotTables,…
- Excel Bar of Pie Chart: How to Configure ItTo configure a Bar of Pie chart in Excel for Microsoft 365 on Windows, select a category-and-value data…
- Excel Dashboard Format: Layout, Design, and SetupAn Excel dashboard is usually a formatted worksheet that brings key measures, charts, and filters together so people…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.