How to Fix Excel Chart Source Data & Automatically Add New Rows
Question details
The user needs a way to inspect missing chart data highlights and ensure that newly added data rows automatically update the corresponding chart.

- Product
- Excel
- Device & OS
- not provided
- Scenario
- Managing an evolving dataset where new rows are frequently added and need to be reflected in an existing chart automatically.
- Observed behavior
- Excel fails to highlight the source data range when the chart is selected, and new data results appended to the dataset are not automatically added to the chart.
Before modifying your chart's source data, ensure your worksheet is not protected and save a backup copy of your dataset to prevent accidental data loss during reconfiguration.
Convert Source Data into an Excel Table for Automatic Updates
Converting your raw data into a dynamic Excel Table is the most efficient way to ensure any new rows you add will automatically populate in connected charts.
By default, charts link to a static range of cells. Formatting this range as an official Excel Table changes it into a dynamic object. As the table expands to accommodate new rows, the chart's source data automatically expands with it.
Highlight the entire block of data, including headers, that your chart is currently based on.
Navigate to the 'Insert' tab on the ribbon menu and click 'Table', or use the keyboard shortcut 'Ctrl + T'.
In the pop-up dialog, verify the data range is correct, check the box for 'My table has headers', and click 'OK'.
Type a new row of data immediately below the table. The table formatting will expand, and your chart will instantly update to include the new data.

Inspect and Edit Chart Series Definitions Manually
If Excel is not highlighting your data on the sheet, it is likely because the series references multiple separate ranges. You can manually inspect and correct these references.
Use WPS Spreadsheet to Build Auto-Updating Charts
WPS Spreadsheet provides powerful tools to format data as dynamic tables and build professional charts. By easily converting your data into a Table, your charts will automatically capture new data entries without tedious manual adjustments.
- 1. Open Your Dataset: Launch WPS Spreadsheet and open the document containing your data.
- 2. Format as Table: Select your dataset, go to the 'Insert' tab, and click 'Table' to turn it into a dynamic source.
- 3. Insert Chart: Select your newly created table, go to the 'Insert' tab, and choose your preferred chart type.
- 4. Add New Rows: Type new information into the row just below the table. The table will absorb it and the chart will update automatically.

Frequently Asked Questions
Why doesn't Excel highlight my chart data range when I click the chart?
Excel highlights the source data with colored borders only when the data is contiguous. If your chart's data series uses multiple, non-adjacent columns or scattered cell ranges, Excel cannot display this unified visual highlight.
Can I use formulas instead of a Table to auto-update charts?
Yes, you can create dynamic named ranges using the OFFSET and COUNTA formulas in the Name Manager, and then apply those named ranges to your chart's data series. However, converting the data to an Excel Table is significantly faster and less prone to formula errors.
How do I remove a data series from my chart without deleting the source data?
Right-click the chart and select 'Select Data'. In the left column under Legend Entries, click on the series name you wish to hide, and click the 'Remove' button. This only removes it from the chart's display, leaving the worksheet data untouched.




