Chart & Visualization Issues

How to Fix Excel Chart Not Updating Data After 2023

WPS Editor Oct 8, 2026 869 views

Question details

The user's Excel chart fails to display new data entries added after the end of the year 2023.

How to Fix Excel Chart Not Updating Data After 2023

Product: Excel
Device & OS: not provided
Scenario: Updating an existing Excel chart with new data for the new year.
Observed behavior: The chart correctly displays historical data but ignores or fails to plot any new rows or dates added after 2023.

Before you start

Ensure that the new data you entered into your spreadsheet is formatted consistently with previous years' data, particularly checking that new dates are recognized as date values rather than text.

Solution 1Recommended

Extend the Chart's Data Source Range

Manually update the chart's data range to include the newly added rows or columns for 2024 and beyond.

By default, Excel charts are often linked to a fixed range of cells. When you add new data outside of this fixed range, the chart does not automatically include it. Updating the source range resolves this immediately.

Select the chart

Click on your existing Excel chart to activate the Chart Tools on the top ribbon.

Open the Select Data dialog

Navigate to the 'Chart Design' tab and click on the 'Select Data' button.

Update the chart data range

In the 'Select Data Source' dialog box, locate the 'Chart data range' field. Modify the cell references to include your newly added rows (for example, change $A$1:$B$100 to $A$1:$B$150).

Apply changes

Click 'OK' to apply the new range. Your chart should now refresh to display the data added after 2023.

Tip: If your chart contains multiple data series, you might need to select each series under 'Legend Entries (Series)' in the dialog and click 'Edit' to manually extend the range for each one.

Solution 2

Convert Source Data to an Excel Table

Formatting your data as a Table ensures that any new rows added will automatically be included in the chart.

Solution 3

Clear Chart Filters Excluding New Data

Check if chart filters are hiding newly added data by restricting the view to older dates.

Seamless Chart Management

Create Dynamic Charts Easily in WPS Spreadsheet

WPS Spreadsheet provides intuitive tools for managing chart data ranges and supports automatic chart updates when using formatted tables. It perfectly handles Microsoft Excel files and complex datasets.

1. Open your file: Launch WPS Spreadsheet and open your existing .xlsx workbook.
2. Convert data to a table: Select your data range, click on the 'Insert' tab, and choose 'Table' to make your data range dynamic.
3. Update the chart source: Click on your chart, go to 'Chart Tools', click 'Select Data', and re-select the newly created table range.
4. Add data seamlessly: Simply type new data at the bottom of your table, and watch your chart update automatically.

Automatically update charts using formatted data tablesFully compatible with Microsoft Excel (.xlsx) formatsIntuitive chart design, formatting, and filtering toolsFree, lightweight, and easy-to-use alternative

microsoft office alternative - wps office

Frequently Asked Questions

Why does my Excel chart stop updating automatically?

This usually happens when the chart is linked to a fixed, static range of cells (e.g., A1:B50). When you add data to row 51, the chart does not know to include it unless you extend the range, convert the data into an Excel Table, or use dynamic named ranges.

How do I make my Excel chart update automatically when I add new data?

The easiest and most reliable method is to format your source data as a Table. Select your data and press Ctrl + T. Any chart created from a Table will automatically expand its data range when new rows or columns are added.

Can incorrect date formats prevent chart updates?

Yes. If the newly added dates are formatted as text instead of actual date values (serial numbers in Excel), the chart may fail to plot them correctly on a time-series axis. You can verify this by changing the cell format to 'General' to see if a numerical value appears.

Excel & Data Problems