Chart & Visualization Issues

Add Series with Different X Ranges to an Excel Chart

Muhammad TalhaMuhammad Talha Nov 18, 2026 871 views

Question details

The user wants to plot multiple data series with different X-value ranges in one Excel chart.

Add Series with Different X Ranges to an 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.
Before you start

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.

Solution 1Recommended

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.

1
Create a scatter chart

Select the first dataset's X and Y values, then choose Insert > Scatter (X, Y) and select a scatter chart style.

2
Open the data source dialog

Click the chart, then choose Chart Design > Select Data.

3
Add the next series

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.

4
Apply and repeat

Click OK to add the series. Repeat Add for any other datasets, then click OK to close the Select Data Source dialog.

Use an XY scatter chart and add each series
Check each pair of ranges: For each series, the X and Y ranges should contain the same number of data points. Different series can have different numbers of points.
Create scatter charts in WPS

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. 1. Open your data: Open the workbook in WPS Spreadsheets and check that each dataset has paired X and Y columns.
  2. 2. Insert a scatter chart: Select the first X and Y ranges, then choose Insert > Chart and select an XY scatter chart.
  3. 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. 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.
Plot series with independent X values in one scatter chart.Open and edit Microsoft Excel XLSX and XLS files.Create and edit charts through a familiar spreadsheet interface.Use WPS Office for free.
QA img-9

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.