Investigate an Extra Line in an Excel XY Scatter Chart
Question details
The user wants to identify why an unexpected line intermittently appears when selecting or highlighting a point in an Excel XY scatter chart.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Repeatedly select or highlight a plotted point near coordinates (0.01029043, -14.0597) and investigate the extra line that may appear.
- Observed behavior
- An extra line sometimes appears after repeated point selection. The user reports that it is not a trendline, and tests with the supplied workbook and recreated charts did not consistently reproduce it.
Open the affected workbook and identify the chart, source ranges, and exact point associated with the extra line. Record your Excel version under File > Account > About Excel, along with how you select or highlight the point.
Compare the affected scatter chart with a minimal test chart
Use this approach to determine whether the extra line depends on the source data, chart configuration, or selection sequence.
The supplied workbook and recreated charts did not consistently reproduce the behavior. No confirmed cause or fix was established, so a controlled comparison is more useful than assuming the line is a trendline or a data error.
Select the affected chart and open Chart Design > Select Data. Select each series and click Edit to inspect its X and Y value ranges. Compare the referenced cells with the intended data, including the point near (0.01029043, -14.0597).
Open Chart Design > Change Chart Type and note the selected XY scatter subtype. Right-click the affected series and choose Format Data Series to inspect its line and marker settings. Record these settings before making changes.
Choose File > New > Blank Workbook and copy only the X and Y values needed to test the affected point. Select those values and use Insert > Scatter (X, Y) to create a chart with the same subtype and series formatting as the original.
In both workbooks, repeat the exact clicks or highlighting actions used when the line appeared. For a point selection, click the series once and then click the individual point. Compare whether the extra line appears under the same conditions.

Capture the workbook state when the extra line appears
Use this approach when the behavior is intermittent and a minimal chart does not reproduce it reliably.
Work with Excel Scatter-Chart Data in WPS Spreadsheets
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and support for Excel .xlsx and .xls files. Open a copy of your workbook in WPS Spreadsheets to review the data and compare chart behavior without rebuilding the entire workbook. This supports a straightforward migration, but it does not repair Excel's intermittent rendering issue.

Frequently Asked Questions
Is the extra line definitely a trendline?
No. The reported line was described as not being a trendline. To check the chart's actual trendline settings, select it and open Chart Design > Add Chart Element > Trendline. Do not remove a legitimate trendline unless it is the unwanted object.
Could the scatter-chart subtype explain a visible line?
Some XY scatter subtypes intentionally connect points with straight or smooth lines. Check Chart Design > Change Chart Type and inspect Format Data Series > Fill & Line. These settings can explain expected connecting lines, but they do not establish the cause of this intermittent extra line.
What should I include in a minimal test workbook?
Use File > New > Blank Workbook and include the relevant X and Y values, the affected point, and a chart with the same subtype and formatting. Keep enough surrounding data to reproduce the behavior, and document the exact selection steps.
What if the extra line disappears when I reopen Excel?
Record that result and capture the issue before reopening the workbook. A temporary display state may not persist in a saved file, so a screen recording, Excel version, and repeatable click sequence are important for investigation.
Will opening the workbook in WPS Office fix the Excel issue?
No confirmed Excel fix follows from opening the file in WPS. In WPS Spreadsheets, use Open to load a copy of the .xlsx or .xls workbook and compare its data and chart display. Differences can inform your investigation, but chart formatting and behavior may vary between applications.




