Add Series with Different X Ranges to an Excel Chart
Question details
The user wants to plot multiple data series with different X-value ranges in one Excel chart.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Create a chart that compares datasets with independent X values.
- Observed behavior
- Each series should use its own X and Y ranges on a shared chart.
Arrange each dataset in paired X and Y columns, with the same number of values in each pair. Identify the cell ranges you want to use for each series.
Use an XY scatter chart and add each series
Use this method when each dataset has its own numerical X values.
An XY scatter chart plots each series using its assigned X and Y values. A line chart typically uses a shared category axis instead.
Select the first dataset's X and Y values, then choose Insert > Scatter (X, Y) and select a scatter chart style.
Click the chart, then choose Chart Design > Select Data.
Under Legend Entries (Series), click Add. Enter or select a series name, then select that dataset's cells for Series X values and Series Y values.
Click OK to add the series. Repeat Add for any other datasets, then click OK to close the Select Data Source dialog.

Plot Independent X Ranges in WPS Spreadsheets
Use an XY scatter chart in WPS Spreadsheets to plot datasets with separate X and Y ranges on the same chart.
- 1. Open your data: Open the workbook in WPS Spreadsheets and check that each dataset has paired X and Y columns.
- 2. Insert a scatter chart: Select the first X and Y ranges, then choose Insert > Chart and select an XY scatter chart.
- 3. Add a series: Select the chart and open Select Data from the chart tools or the chart's right-click menu. Click Add to create another series.
- 4. Set the ranges: Select the new series' X and Y ranges in the series settings, then confirm the dialog. Repeat for each remaining dataset.

Frequently Asked Questions
Why should I use a scatter chart instead of a line chart?
An XY scatter chart lets each series use its own numerical X values. A line chart typically plots series against a shared category axis.
Can the series have different numbers of data points?
Yes. Each series can have a different length, but its own X and Y ranges should contain the same number of values.
How do I change the X values of an existing series?
Select the chart, choose Chart Design > Select Data, select the series under Legend Entries, and click Edit. Change the Series X values range and click OK.
Can I use an existing line chart for independent X ranges?
Select the chart and choose Chart Design > Change Chart Type, then select an XY scatter chart. Check each series under Chart Design > Select Data and assign its X and Y ranges.




