Chart & Visualization Issues

Create a Four-Line XY Scatter Chart in Excel From Coordinate Data

Khadija KhanKhadija Khan Nov 20, 2026 869 views

Question details

Create an XY scatter chart with four separate lines from coordinate pairs that are not arranged in order.

Create a Four-Line XY Scatter Chart in Excel
Product
Microsoft Excel
Device & OS
not provided
Scenario
The user has four equations or data sets and wants to plot each set of X and Y coordinates as a separate line.
Observed behavior
The desired chart has four series, each connecting its own coordinate pairs in the intended order.
Before you start

Identify the matching X and Y value for each point in all four data sets. Decide whether each line should connect points in increasing X order or in another specific sequence.

Solution 1Recommended

Add Four Coordinate Series to an Excel XY Scatter Chart

Use separate chart series and helper columns to plot unordered or nonadjacent coordinates reliably.

1
Arrange the coordinate pairs

In the worksheet, create an X column and a Y column for each line. Copy or link each matching coordinate pair into the same row, and arrange the rows in the order the points should be connected.

2
Insert a scatter chart

Select the first line's X and Y columns, then choose Insert > Scatter (X, Y) > Scatter with Straight Lines and Markers.

3
Open the series settings

Right-click the chart and choose Select Data. Remove any unwanted default series, then click Add to create or replace a series.

4
Set each line's values

In Edit Series, enter a series name and select the contiguous X and Y ranges for one line. Click OK, then use Add to repeat for the remaining lines until the chart has four series.

5
Check the result

Inspect the chart and legend to confirm each line uses the correct points. If a line connects points in the wrong order, rearrange its paired rows in the worksheet.

Add Four Coordinate Series to an Excel XY Scatter Chart
Keep coordinate pairs together: Sort or rearrange each line's X and Y values together. Sorting only one column changes which coordinates are paired.
Plot coordinate data in WPS

Create a Four-Line Scatter Chart in WPS Spreadsheets

Use WPS Spreadsheets to organize coordinate pairs and add each data set as a separate XY scatter chart series.

  1. 1. Open and arrange the data: Open the workbook in WPS Spreadsheets. Place each line's matching X and Y values in two adjacent columns, with points in the intended connection order.
  2. 2. Insert the chart: Select the first X and Y columns, then choose Insert > Chart and select an XY scatter chart with lines.
  3. 3. Add the other series: Select the chart and open Select Data from the chart tools or chart context menu. Add each remaining series, specifying its name and corresponding X and Y ranges.
  4. 4. Review and save: Check the four lines and legend, adjust the paired worksheet rows if needed, and use File > Save As to save the workbook.
Plot four coordinate data sets as separate chart seriesOpen and edit Microsoft Excel XLS and XLSX workbooksArrange and check coordinate pairs in a familiar spreadsheet interfaceCreate and edit charts with a free, easy-to-use office suite
microsoft office alternative - wps office

Frequently Asked Questions

Why are the points connected in the wrong order?

An XY scatter chart connects points in their series order. Rearrange the paired X and Y rows in the worksheet into the desired sequence; use increasing X order if that is how the line should be drawn.

How do I add another line to an existing Excel scatter chart?

Right-click the chart, choose Select Data, and click Add. Enter the series name and select its X and Y value ranges, then click OK.

What if the coordinates for one line are in nonadjacent cells?

Copy or link the matching X and Y values into adjacent helper columns, keeping each pair on the same row. Use those contiguous columns as the series ranges in Select Data.

How is an XY scatter chart different from a line chart?

An XY scatter chart uses numeric X values to position points along the horizontal axis. Choose Insert > Scatter (X, Y) when the actual spacing between coordinates matters.