Show Scatter Plot Markers in Front of Lines in Excel
Question details
The user wants scatter plot markers to appear in front of a smooth-line series in an Excel chart.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A chart contains overlapping scatter markers and a smooth-line series, and the user wants to control their visual layering.
- Observed behavior
- The smooth-line series appears in front of the scatter markers instead of behind them.
Select the chart and identify which series contains the markers and which contains the smooth line. Check whether both series use an XY scatter chart type and the same axis, since mixed chart types or secondary axes can affect layering.
Change the plotting order to bring scatter markers forward
Use this approach when the overlapping series share a chart type and axis.
For series in the same chart group, Excel generally draws later series over earlier ones. Move the marker series toward the bottom of the series list, rather than assuming that the top entry appears in front.
Click the chart, then choose Chart Design > Select Data. You can also right-click the chart and choose Select Data.
Under Legend Entries (Series), select the scatter marker series. Use the Move Down arrow to place it after the smooth-line series, ideally at the bottom of the list.
Click OK and inspect a point where a marker overlaps the line. If the marker still appears behind the line, check the series chart types and axis assignments using the next solution.

Check chart types and axes when reordering does not work
Use this approach if the ordering controls are unavailable or the line still covers the markers.
Work with Excel chart workbooks in WPS Spreadsheet
WPS Office is a free, lightweight alternative for everyday spreadsheet and chart work. Its familiar interface and support for Excel formats make migration straightforward, though it does not repair Excel's chart-layering behavior and complex charts should be checked after opening.

Frequently Asked Questions
Should the scatter series be first or last in Excel's series list?
For series in the same chart group, the later series is generally drawn on top. Open Chart Design > Select Data and move the scatter marker series below the smooth-line series, then check the overlap.
Why does the line still cover my markers after I change the order?
The series may belong to different chart groups or use different axes. Check Chart Design > Change Chart Type and Format Data Series > Series Options. The list order alone may not control layering across those groups.
Can I display a smooth curve and separate points in one scatter chart?
Yes. Add the curve and points as separate XY scatter series. In Chart Design > Change Chart Type, use a smooth-line scatter variant for the curve and a markers-only scatter variant for the points, where available.
What should I share if someone needs to troubleshoot my chart?
Create a separate workbook containing dummy data and the chart that reproduces the issue. Keep the series types, axis assignments, and plotting order unchanged, remove sensitive information, and share the sample through OneDrive or another approved service.




