Make an Excel Scatter Chart Retain X-Value Ranges
Question details
The user wants a reusable Excel scatter chart that retains the intended 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.
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.
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.
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.
Select the chart border and use Copy and Paste to create a duplicate.
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.

Assign Scatter Chart Series Ranges with VBA
Use a VBA macro in desktop Excel when you need to reassign ranges repeatedly after creating a chart.
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.

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.




