Excel Chart Won’t Update With New Data? Causes and Fixes

If an Excel chart will not update with new data, first check whether its source range includes the new cells: select the chart, choose Chart Design > Select Data, and inspect the chart data range. For data you expect to keep adding to, convert the source range to an Excel table so the chart can include rows added to that table.

Why a chart can miss new data

A chart displays the cells in its source, not every value that happens to sit near those cells. If the chart points to A1:B10 and you type a new record in row 11, Excel may leave the chart’s source unchanged. The new record exists in the worksheet, but it is outside the chart’s instructions.

Excel sometimes extends a chart automatically when you type or paste immediately beside its source data. That behavior depends on how the range is arranged and how the data is entered, so it is not a reliable substitute for checking the chart’s references. Pasting a block, leaving a blank row, or adding a new column can produce a different result.

There are also cases where the source includes the new cells but the chart still looks unchanged. A filter may hide the new category, the chart may be plotting a different column, or a PivotChart may need its underlying PivotTable refreshed. Identifying which situation applies is faster than rebuilding the chart.

Check and extend the chart’s source range

In Excel for Microsoft 365 on Windows, click the chart and select Chart Design > Select Data. The Select Data Source dialog shows the range used for the chart and the individual series. Compare those references with the location of the new data.

Check the Chart data range field. If it ends at row 10 but your data now runs through row 11, expand the range to include the added row.
Check each entry under Legend Entries (Series). Select a series and choose Edit to inspect its series name and values.
Check the Horizontal (Category) Axis Labels if the new category name does not appear.
Select OK and confirm that the chart now displays the added data.

For example, a chart based on A1:B10 will not necessarily include a value entered in B11. If the table has a header in row 1 and ten records in rows 2 through 11, the chart’s range needs to cover those headers and records, such as A1:B11. When you edit a range in the dialog, take care not to omit the header or include unrelated cells.

On Mac, select the chart and use the Chart Design tab’s Select Data command; wording and ribbon layout can vary slightly by Excel release. Excel for the web has a more compact interface, but selecting the chart and looking for its chart design or data options is the equivalent approach. If you cannot edit the source easily in the web app, open the workbook in the desktop app.

Use an Excel table for data that grows

An Excel table is usually the simplest way to make a chart source easier to maintain. Select a cell in the data, choose Insert > Table, confirm the range and whether it has headers, and select OK. You can also use Ctrl+T on Windows or Command+T on Mac. Then create a chart from the table, or update an existing chart so its source uses the table data.

When you enter or paste a record directly in the row immediately below a table, Excel normally expands the table to include it. A chart based on that table can then include the added record without manually changing a fixed cell range. Check that the table really expanded: a row pasted with unusual formatting or a blank row between the table and new data may remain outside it.

Use one header row with a clear name for each field.
Keep each record in one row and avoid completely blank rows inside the table.
Add new records at the bottom of the table, rather than in a separate range nearby.
If the chart already exists, inspect its source in Select Data; converting cells to a table does not guarantee that an older chart has been connected to the table in the way you intended.

Tables are especially useful for monthly sales, survey results, inventory, and other lists that gain records over time. They do not correct every chart issue: a table can expand while a chart still uses a different range, or a filter can still hide values. Verify the result after setting up the chart.

Make sure the chart is plotting the intended series

Sometimes the chart has updated, but it does not show the information you expected. In Select Data, confirm that the new values belong to the series being charted and that the category labels come from the intended column. For instance, if column A contains dates, column B contains actual sales, and column C contains targets, a chart based only on columns A and B will not display targets added in column C.

To add another series, use Chart Design > Select Data and choose Add under Legend Entries (Series). Specify the series name and the cells containing its values, then check the category-axis labels. If the chart has dates or category names on the wrong axis, use Switch Row/Column in the same area to test whether Excel interpreted rows and columns opposite to your intention.

Also check the chart’s filters. Select the chart and look for the Chart Filters button, shown as a funnel beside the chart in desktop Excel. A cleared category or series can make valid source data appear missing. Select the desired items and apply the change. Filters on the worksheet table can affect what a chart displays too, depending on the chart settings and how the data is arranged.

Check hidden cells, blanks, and chart type

New cells can be inside the source range and still fail to appear as expected if rows or columns are hidden, or if the cells contain formulas returning an empty string rather than a visible value. Select the chart, choose Chart Design > Select Data, and open Hidden and Empty Cells. The available options let you control whether data in hidden rows and columns is shown and how empty cells are displayed. The exact choices depend on the chart and Excel version.

A blank cell is not the same as zero. A line chart may show a gap where a value is blank, while a zero can pull the line down to the axis. A formula that returns an empty string may also behave differently from a truly empty cell. If a new category appears on the axis but no point appears, inspect the worksheet cell’s contents and the chart’s empty-cell settings before changing the source.

Consider whether the chart type fits the data. A stacked chart, a secondary axis, or a date axis can make a small new value hard to notice. A new category may be present but crowded against existing labels, or a large earlier value may compress the visible scale. Look for the category in the axis and inspect the plotted values, rather than assuming that no visible change means the chart failed to update.

Refresh PivotCharts and external data

A PivotChart is connected to a PivotTable, so changing the worksheet data alone may not update the chart. Click inside the PivotTable and choose PivotTable Analyze > Refresh, or use Data > Refresh All to refresh workbook connections and queries. The PivotChart then reflects the refreshed PivotTable, subject to its filters and layout.

If new records are not included after refreshing, inspect the PivotTable’s source. A PivotTable built from a fixed range may not cover rows added below that range. Choose PivotTable Analyze > Change Data Source and check the selected range, or use an Excel table as the PivotTable source so added records can be included more easily. After changing a source, refresh again.

Charts connected to Power Query results or other external data also depend on refresh. Use Data > Refresh All, and check whether the query or connection completed successfully. A chart cannot show records that have not been loaded into its worksheet or data model. If a refresh requires credentials, a network connection, or a permitted data source, resolve that issue first. Excel for the web may not support every connection or refresh option available in desktop Excel.

Distinguish chart updates from formula recalculation

If chart source cells contain formulas, first check whether those cells themselves show current results. On Windows, select Formulas > Calculation Options > Automatic if the workbook is set to manual calculation. You can also press F9 to recalculate open workbooks, or Shift+F9 to calculate the active worksheet. On Mac, the calculation options are on the Formulas tab; keyboard shortcuts differ by keyboard and Excel release.

Calculation and chart sourcing are separate issues. Automatic calculation updates formula results, but it does not expand a chart’s fixed source range. Conversely, changing a chart range will not fix a formula that has not recalculated. Check the displayed worksheet values first, then check whether the chart includes those cells.

A reliable troubleshooting order

Use this sequence to isolate the cause without changing several settings at once:

Confirm that the new data is present and correct in the worksheet.
Select the chart and inspect its source range and series in Chart Design > Select Data.
Expand the range or connect the chart to the growing table, as appropriate.
Check chart filters, hidden rows or columns, category labels, and the selected chart type.
If it is a PivotChart or connected chart, refresh its source and confirm that the source includes the new records.
If the chart uses formulas, verify the cell results and calculation mode.

Save the workbook after confirming the chart displays the intended categories and values. If the workbook is shared, make sure the saved version—not just an unsaved local copy—contains the updated source range and chart.

Frequently Asked Questions

Why does my Excel chart stop at the last row?
Most often, the chart uses a fixed range that ends before the new row. Select the chart, open Chart Design > Select Data, and extend the range or use a table-based source for data that will grow.

Will an Excel chart update automatically when I add a row?
It may expand automatically in some layouts, but you should not rely on that behavior for every entry method or workbook. A chart based on an Excel table is generally easier to keep current when you add records directly to the table.

Why is my new data in the source range but not visible?
Check whether the chart or worksheet has filters, whether rows or columns are hidden, and whether the plotted cells are blank or return empty text. Also verify that the new values belong to the series the chart displays.

Does pressing F9 fix a chart that will not update?
F9 recalculates formulas, so it can help when chart source cells show stale formula results. It does not expand a chart’s source range or refresh every external connection; check those separately.

How do I update an Excel PivotChart?
Refresh its underlying PivotTable with PivotTable Analyze > Refresh or use Data > Refresh All. If new rows remain excluded, check or change the PivotTable’s source range and refresh again.

What to remember

When a chart appears stuck, start with its source range: charts only plot data they are connected to. Then check whether the intended series and categories are selected, whether filters or hidden cells affect visibility, and whether a PivotTable or external connection needs refreshing. For a recurring report, organizing source records as an Excel table is a practical way to reduce range-maintenance problems and make new rows easier to include.

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.