Chart & Visualization Issues

Fix Excel Scatter Plot Straight Lines and Markers

Phi Hung VoPhi Hung Vo Nov 18, 2026 871 views

Question details

The user needs an Excel XY scatter chart to display straight lines and markers as expected.

Fix Excel Scatter Plot Straight Lines and Markers
Product
Microsoft Excel
Device & OS
not provided
Scenario
The user selects the Straight Lines and Markers scatter chart option for a set of X and Y values.
Observed behavior
The resulting scatter plot does not show the expected straight-line connections.
Before you start

Locate the intended X and Y ranges and check that their values are numeric. Note whether the points should be connected in worksheet order or in ascending X-value order.

Solution 1Recommended

Check the source data and create an XY scatter chart

Use this method when the chart has incorrect points or does not connect the intended values.

1
Arrange the data

In the worksheet, place numeric X values in one column and their corresponding numeric Y values in the adjacent column. Check for text values and unintended blank cells.

2
Check point order

Review the rows in the source range. Excel connects points in their data order, so sort both columns together by X if the line should run from the lowest to the highest X value.

3
Insert the scatter chart

Select the intended X and Y columns, then choose Insert > Scatter (X, Y) > Scatter with Straight Lines and Markers.

4
Verify the series ranges

If the chart is still incorrect, right-click it and choose Select Data. Select the series, click Edit, and check that Series X values and Series Y values refer to the intended ranges.

Check the source data and create an XY scatter chart
Point order matters: Straight lines connect consecutive data points; they do not automatically create a single best-fit line.
Create scatter charts in WPS Office

Create a straight-line scatter chart in WPS Spreadsheets

Use WPS Spreadsheets to arrange numeric X and Y data and create an XY scatter chart with straight lines and markers.

  1. 1. Open the workbook: Open WPS Spreadsheets and use Open to select your Excel workbook.
  2. 2. Prepare the data: Place numeric X and Y values in adjacent columns and check for unintended blanks or text.
  3. 3. Select the ranges: Select the X and Y columns you want to plot, including their headings if present.
  4. 4. Insert the chart: Choose Insert > Chart, select an XY scatter chart with straight lines and markers, and insert it into the worksheet.
Plot numeric X and Y values with straight-line connectionsOpen and edit Microsoft Excel XLSX and XLS filesUse a familiar spreadsheet interface for organizing chart dataCreate and edit spreadsheets for free
microsoft office alternative - wps office

Frequently Asked Questions

Why does my scatter plot line zigzag?

Excel connects points in their worksheet order. If you want the line to progress from left to right, sort the X and Y columns together by X value.

How do I check which values Excel uses for each axis?

Right-click the chart, choose Select Data, select the series, and click Edit. Check the Series X values and Series Y values ranges.

Can I connect points across a blank cell?

Right-click the chart and choose Select Data > Hidden and Empty Cells. Select Connect data points with line if it is available. The missing value itself remains blank.

Does Straight Lines and Markers create a best-fit line?

No. It connects consecutive points in the series. For a best-fit line, select the chart and use Chart Design > Add Chart Element > Trendline.