Fix Excel Chart Data Range Disappearing After Saving an XLS File
Question details
The user needs to keep an Excel line chart's data range intact after saving and reopening a workbook.

- 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.
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.
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.
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.
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.
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.

Recreate the chart in a new XLSX workbook
Use a new workbook if the chart still loses its data range after conversion, as the original workbook may be damaged.
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.

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.




