Chart & Visualization Issues

Show Scatter Plot Markers in Front of Lines in Excel

Rana GarciaRana Garcia Nov 13, 2026 869 views

Question details

The user wants scatter plot markers to appear in front of a smooth-line series in an Excel chart.

Show Scatter Plot Markers in Front of Lines in Excel
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.
Before you start

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.

Solution 1Recommended

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.

1
Open the series list

Click the chart, then choose Chart Design > Select Data. You can also right-click the chart and choose Select Data.

2
Move the marker series later

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.

3
Check the chart

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.

Change the plotting order to bring scatter markers forward
Series order also affects the legend: Changing the series order may change the legend order. Mixed chart groups and primary-versus-secondary axes can also prevent the series list from fully controlling visual layering.
Free Microsoft Office alternative

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.

Open and edit Microsoft Excel .xlsx and .xls workbooks.Use spreadsheet chart tools to work with numeric data and scatter charts.Navigate a familiar ribbon-style interface with less relearning.Move everyday spreadsheet work to a lightweight, free Office alternative.
microsoft office alternative - wps office

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.