Fix Excel Scatter Plot Straight Lines and Markers
Question details
The user needs an Excel XY scatter chart to display straight lines and markers as expected.

- 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.
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.
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.
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.
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.
Select the intended X and Y columns, then choose Insert > Scatter (X, Y) > Scatter with Straight Lines and Markers.
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.

Adjust how the scatter chart handles empty cells
Use this method when missing worksheet values cause gaps between plotted points.
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. Open the workbook: Open WPS Spreadsheets and use Open to select your Excel workbook.
- 2. Prepare the data: Place numeric X and Y values in adjacent columns and check for unintended blanks or text.
- 3. Select the ranges: Select the X and Y columns you want to plot, including their headings if present.
- 4. Insert the chart: Choose Insert > Chart, select an XY scatter chart with straight lines and markers, and insert it into the worksheet.

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.




