Chart & Visualization Issues

Make an Excel Scatter Chart Retain X-Value Ranges

Ayan MasoodAyan Masood Nov 18, 2026 870 views

Question details

The user wants a reusable Excel scatter chart that retains the intended X-value ranges.

Make an Excel Scatter Chart Retain X-Value Ranges
Product
Microsoft Excel
Device & OS
not provided
Scenario
A scatter chart template is applied to create charts from worksheet data.
Observed behavior
The template preserves formatting, but new charts use series sequence numbers instead of the intended X-cell values.
Before you start

Check that the X cells contain numeric values and that the chart type is XY Scatter, not Line. Identify the X and Y ranges for each series before configuring the chart.

Solution 1Recommended

Duplicate a Scatter Chart with Correctly Configured Ranges

Use a configured chart as a starting point when your data follows a consistent layout.

Chart templates primarily preserve formatting and may not reliably retain source ranges when applied to a different data layout. A copied chart can retain its source references, so verify them before using new data.

1
Configure the original chart

Select the scatter chart, then choose Chart Design > Select Data. Select a series, click Edit, and set Series X values and Series Y values to the intended worksheet ranges.

2
Copy the chart

Select the chart border and use Copy and Paste to create a duplicate.

3
Check the duplicate's references

On the copied chart, open Chart Design > Select Data and edit each series if its ranges still point to the original data. If you reuse the same source cells, replace their values to update the chart.

Duplicate a Scatter Chart with Correctly Configured Ranges
Free Microsoft Office alternative

Create Scatter Charts with WPS Spreadsheets

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open compatible Excel files and create or edit scatter charts as you move your spreadsheet work to WPS.

Create scatter charts from numeric worksheet dataOpen and edit compatible Microsoft Excel XLSX and XLS filesWork in a familiar, easy-to-use spreadsheet interfaceMove existing spreadsheets to a lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Why does my scatter chart show sequence numbers instead of my X values?

The series may not have a valid X-value range assigned. Select the chart and open Chart Design > Select Data, then edit the series and select the numeric cells under Series X values.

Does an Excel chart template save my source ranges?

A chart template primarily preserves formatting and may not reliably retain source ranges for a different data layout. Check each series through Chart Design > Select Data after applying the template.

How do I check that I am using an XY scatter chart?

Select the chart, choose Chart Design > Change Chart Type, and check that XY (Scatter) is selected rather than Line.

Will a copied chart automatically use data from a new worksheet?

Not necessarily. Open Chart Design > Select Data on the copied chart and check each series reference; edit the X and Y ranges if they still point to the original worksheet.