Create a Four-Line XY Scatter Chart in Excel From Coordinate Data
Question details
Create an XY scatter chart with four separate lines from coordinate pairs that are not arranged in order.

- 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.
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.
Add Four Coordinate Series to an Excel XY Scatter Chart
Use separate chart series and helper columns to plot unordered or nonadjacent coordinates reliably.
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.
Select the first line's X and Y columns, then choose Insert > Scatter (X, Y) > Scatter with Straight Lines and Markers.
Right-click the chart and choose Select Data. Remove any unwanted default series, then click Add to create or replace a series.
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.
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.

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. 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. Insert the chart: Select the first X and Y columns, then choose Insert > Chart and select an XY scatter chart with lines.
- 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. 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.

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.




