Excel Chart Not Updating? Fix the Data Range and Refresh

If an Excel chart is not updating with new data, first check that its source range includes the new cells: select the chart, choose Chart Design > Select Data, and inspect the chart data range. If the range is correct, check whether the values have recalculated, whether filters are hiding the data, or whether the chart is a PivotChart that needs a refresh.

Start by identifying what is not updating

A chart can appear stale for several different reasons. The source cells might contain new values that the chart is not linked to; the chart might link to the right cells but those cells have not recalculated; or the data may be present but hidden by a filter or chart setting. A PivotChart adds another layer because its display depends on the PivotTable cache and source.

Look at the worksheet cells first. Are the new records visible, and do any formulas in the source data show the expected results? Then click the chart and check whether its displayed categories, series, and values match those cells. This quick comparison helps separate a chart-range problem from a calculation or refresh problem.

For a regular chart in Excel for Microsoft 365 on Windows, select the chart and open Chart Design > Select Data. The Chart data range box and the entries under Legend Entries (Series) and Horizontal (Category) Axis Labels show what Excel is plotting. You can also right-click the chart and choose Select Data. On Mac, select the chart and use the Chart Design tab’s Select Data command; ribbon labels can vary slightly with the Excel build. Excel for the web has a more limited chart-editing interface, so use the desktop app if you cannot access the source settings you need.

Check and correct the chart’s source range

A normal chart plots the cells in its source range. If the chart was created from A1:B10, typing another record into row 11 does not necessarily make the chart include row 11. The chart may still be working exactly as configured: its source simply ends above the new data. This is especially common when a chart was created from a fixed block of cells and data is appended later.

In Select Data, inspect the displayed range and series. If the new row is outside the range, expand the range to include it, or edit the relevant series and category labels. For example, a chart may use column A for month names and column B for sales. Extending only the sales values without extending the month labels can produce an unlabeled point or an incomplete category axis.

For a quick adjustment, you can close the dialog, select the chart, and drag the colored outlines around its source data on the worksheet to include the extra cells. This is convenient for a small, one-time change. The Select Data dialog is usually clearer when a chart has several series, nonadjacent ranges, or a category-label range that needs separate attention.

Confirm that every intended series includes the new data row or column.
Check that the category labels cover the same number of records as the values.
Look for a range that stops at an old last row, such as row 20, when the latest data is on row 21.

Use an Excel Table for data that keeps growing

If you regularly add records, store the source data in an Excel Table instead of a plain cell range. Select a cell in the data and choose Insert > Table, or press Ctrl+T on Windows. Confirm that the range is correct and that My table has headers is selected when the first row contains column names. On Mac, Ctrl+T may not be the same shortcut; use Insert > Table from the ribbon.

Create the chart from the table, or update an existing chart’s source to use the table data. When you type or paste a new record directly into the row immediately below the table, Excel normally expands the table and a chart based on it can include the added record. That is more dependable than relying on a fixed range. Check that the table actually expanded: pasting a large block, placing data beside the table, or leaving a blank row can make Excel interpret the addition differently than expected.

Tables also make the data easier to maintain because headers identify fields and filters are available in the header row. They do not correct every chart issue, though. A chart that was created from a separate fixed range may remain linked to that range even if a nearby table grows. Use Select Data to verify the chart’s source after converting or reorganizing the data.

Make sure formulas have recalculated

When chart source cells contain formulas, the chart can only plot the results currently held in those cells. If calculation is set to Manual, changing an input may leave formula results—and therefore the chart—unchanged until you recalculate. This can look like a chart refresh problem even though the chart is linked to the right cells.

On Windows, open Formulas > Calculation Options and choose Automatic. If the workbook is in Manual mode, changing that setting can recalculate formulas in the workbook. You can also press F9 to calculate open workbooks. On Mac, use Formulas > Calculation Options if available in your Excel build; keyboard shortcuts for recalculation differ from Windows, so use the ribbon command when unsure. In Excel for the web, calculation behavior and controls can differ from desktop Excel.

Check whether the source formulas themselves display current results before changing the chart range. If a formula depends on another workbook, a query, or an external connection, the input may need to be updated or refreshed separately. Recalculation does not fetch every external data source automatically; use the appropriate refresh command for that connection and verify the resulting worksheet values.

Look for filters, hidden rows, and blank cells

Worksheet filters can hide records, and chart filters can hide categories or series. Select the chart and look for the Chart Filters button, often shown as a funnel beside the chart. Open it and review which categories and series are selected, then choose Apply if you change the selection. Also check any filter arrows in the source table or range; a filtered-out row may not appear in the chart.

Charts generally omit data in hidden rows and columns unless configured to plot it. To check the chart setting, open Chart Design > Select Data, choose Hidden and Empty Cells, and review Show data in hidden rows and columns. The exact dialog options may vary by chart type or Excel version. Turning on that option can make hidden source values visible in the chart, but it does not unhide the worksheet rows themselves.

Blank cells can also change how a chart looks. In the Hidden and Empty Cells dialog, Excel offers choices for how to display empty cells, such as gaps, zeroes, or connecting data points with a line, depending on the chart type. A formula that returns an empty string may behave differently from a truly empty cell. If a line appears broken or a point seems missing, inspect the source cells and this setting before assuming the data range is wrong.

Refresh a PivotChart or connected data

A PivotChart is linked to a PivotTable, not directly to an ordinary worksheet range in the same way as a basic chart. Adding records to the underlying source does not guarantee that the PivotTable’s displayed results change immediately. Click inside the PivotTable and choose PivotTable Analyze > Refresh, or use Data > Refresh All to update workbook connections and supported PivotTables. The tab may appear as Analyze in some Excel builds.

If newly added rows are not part of the PivotTable’s source, refresh alone will not bring them in. Click inside the PivotTable and choose PivotTable Analyze > Change Data Source to inspect or extend the source range. If the source is an Excel Table, adding rows to the table and refreshing the PivotTable is often easier to maintain. After changing the source, refresh and check that the new categories or values appear in the PivotTable as well as in the PivotChart.

Do not expect Select Data to work like it does for a regular chart when adjusting a PivotChart’s plotted series. PivotChart fields are controlled through the associated PivotTable and its field layout. If the PivotTable is correct but the PivotChart still looks unexpected, check its field buttons, filters, and chart type.

Fix common mismatches in series and chart structure

Sometimes the source range is correct but Excel is interpreting its rows and columns differently than intended. In Select Data, use Switch Row/Column to change whether rows or columns become series. For example, if each month should be a separate series but Excel has made each product a series, switching the orientation may restore the intended layout. Check the legend and axis labels afterward; the best orientation depends on how the table is arranged.

Also confirm that the source data is suitable for the chart type. A line chart uses a category axis for labels, while an XY (Scatter) chart uses numeric x-values. If dates or numbers are stored as text, Excel may treat them as labels or fail to position points as expected. Changing the cell format alone does not always convert text into real dates or numbers; inspect the cell values and convert the underlying data if needed.

Other things worth checking include accidentally selecting the wrong worksheet cells, a series that points to an old column, and a chart title or axis title that is static text rather than linked to a cell. A title that does not change does not prove the plotted data is stale. Similarly, a chart may display only a selection of points because of a filter or because some values are blank or nonnumeric.

Build a chart setup that is easier to maintain

For recurring reports, keep one clear header row, one record per row, and a consistent column for each field. Avoid inserting subtotal rows or merged cells inside the source data: they can complicate selection, sorting, and charting. Convert the dataset to a Table, build the chart from that Table, and add new records directly below it. This reduces the chance that next week’s records fall outside a fixed chart range.

When a report uses PivotTables, make the refresh step part of the update routine. Add new records to the source, confirm the source includes them, and refresh the PivotTable or use Data > Refresh All when appropriate. Before sharing the workbook, compare a few chart values with their source cells and check any active filters. These habits help distinguish a genuinely outdated chart from a correct chart that is showing only a filtered subset.

Frequently Asked Questions

Why does my Excel chart stop at the previous row?
A chart created from a fixed cell range may not include rows added below that range. Use Chart Design > Select Data to extend the source, or base the chart on an Excel Table that expands as you add records.

Will an Excel chart update automatically when I add data?
It can, if the chart’s source includes the new cells or is based on a growing Table. A chart linked to a fixed range may not expand automatically. PivotCharts also generally need their PivotTable refreshed after the source changes.

Why is my chart not updating when the cells change?
Check that the chart points to those cells, then verify that formulas have recalculated. Also look for chart or worksheet filters, hidden rows, blank values, and external data that has not been refreshed.

How do I refresh a PivotChart in Excel?
Click its PivotTable and choose PivotTable Analyze > Refresh, or choose Data > Refresh All. If the new records are outside the PivotTable source, update the source with PivotTable Analyze > Change Data Source before refreshing.

Why does Excel show only some of my chart data?
Review the chart’s category and series selections, worksheet filters, and the Chart Filters button. Then check whether the source rows or columns are hidden and whether the chart is set to plot hidden data.

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.