Chart & Visualization Issues

Fix Excel Chart Data Range Disappearing After Saving an XLS File

Muhammad TalhaMuhammad Talha Nov 14, 2026 869 views

Question details

The user needs to keep an Excel line chart's data range intact after saving and reopening a workbook.

Fix an Excel Chart Data Range That Disappears After Saving an XLS File
Product
Microsoft Excel
Device & OS
not provided
Scenario
A line chart is updated each month in a workbook repeatedly saved in the older XLS format.
Observed behavior
The chart loses its data range after the XLS file is saved and reopened.
Before you start

Open the workbook and note the worksheet cells used by the chart, including the labels and monthly data. Select the chart and check Chart Design > Select Data to see which series and ranges are currently listed.

Solution 1Recommended

Save the Excel workbook as an XLSX file

Use the modern XLSX format to avoid potential chart compatibility issues associated with the legacy XLS format.

1
Save in the modern format

In Excel, choose File > Save As, select a location, and choose Excel Workbook (*.xlsx) as the file type. Give the file a name and select Save.

2
Check the chart range

Select the line chart, then choose Chart Design > Select Data. If a series or range is missing, use Add or Edit to select the correct worksheet cells.

3
Reopen and test

Save and close the XLSX workbook, then reopen it. Select the chart and open Chart Design > Select Data to confirm that the series and ranges remain.

Save the Excel workbook as an XLSX file
Keep the original file: Save As creates a separate XLSX file. Changing the filename extension alone does not convert the workbook.
Free Microsoft Office alternative

Work with Excel charts in WPS Spreadsheets

WPS Office is a free, lightweight alternative with a familiar interface for working with spreadsheets. Open compatible Excel files in WPS Spreadsheets and continue working with charts as you migrate your documents.

Create and edit line charts for monthly dataCompatible with Microsoft Excel XLS and XLSX formatsUse a familiar spreadsheet interfaceOpen existing files to support an easy transition from Microsoft Office
microsoft office alternative - wps office

Frequently Asked Questions

Why does my chart lose its data range in an XLS file?

The legacy Excel 97–2003 format can cause chart compatibility issues, and workbook damage is another possibility. Try File > Save As and choose Excel Workbook (*.xlsx), then reopen the saved file to test the chart.

How do I restore a missing line chart series?

Select the chart and choose Chart Design > Select Data. Use Add or Edit to specify the series name and worksheet ranges, then save and reopen the workbook to check that they remain.

Can I convert XLS to XLSX by renaming the file?

No. Open the file in Excel and use File > Save As, then select Excel Workbook (*.xlsx) as the file type.

What should I do if the chart still loses its range in XLSX?

Copy the source data cells into a new XLSX workbook without copying the old chart. Select the data, create a new chart through Insert > Line or Area Chart, and test it after saving and reopening.