Fix Excel Scatter Plot Series Display Order & Overlapping Markers
Question details
Users experience an issue where Excel scatter chart series with both lines and markers appear behind marker-only series, despite the configured series display order.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Creating or editing a scatter plot in Excel with multiple overlapping data series.
- Observed behavior
- Series formatted with both lines and markers incorrectly render behind series formatted with only markers, causing a visual conflict that ignores the established series display order.
Before adjusting your chart settings, ensure your Microsoft Office is updated to the latest version, as visual rendering glitches are frequently resolved in official patch updates.
Adjust Marker Transparency and Size
Modify the visual formatting of the overlapping markers to ensure both series remain visible regardless of the rendering order.
Since this issue is primarily a chart rendering behavior within Excel's engine, applying transparency and resizing elements is the most effective workaround to reveal hidden lines.
Right-click the overlapping marker-only series in your scatter plot and choose 'Format Data Series' from the context menu.
Navigate to the 'Fill & Line' section (paint bucket icon), select 'Marker', and increase the Fill Transparency (e.g., 30-50%) so underlying lines and markers show through.
Reduce the marker size of the overlapping series under 'Marker Options', or select the background series to increase its line width for better visibility.

Change Series Overlap Order Manually
Attempt to force the chart engine to re-render the layers by modifying the series order explicitly in the data source settings.
Update Microsoft Office
Update Office to the latest version to fix potential bugs causing chart rendering errors.
Create Flawless Scatter Plots with WPS Spreadsheet
Avoid rendering bugs and layering issues by using WPS Spreadsheet to create and format complex scatter plots with ease. WPS Office offers precise control over chart series order and formatting, ensuring your data visualizations look exactly as intended.
- 1. Open Data in WPS: Launch WPS Spreadsheet and open your existing dataset or Excel file.
- 2. Insert a Scatter Chart: Highlight your data cells, navigate to the 'Insert' tab, click 'Chart', and choose the 'Scatter' option.
- 3. Format Series Order: Right-click the chart area, select 'Select Data', and accurately adjust the series order using the arrow controls for perfect layering.

Frequently Asked Questions
Why do my scatter plot lines disappear behind markers in Excel?
This is often a rendering behavior in Excel where series with both lines and markers are pushed behind marker-only series, regardless of the designated series order in the Select Data settings.
How do I make markers transparent in an Excel chart?
Right-click the data series on your chart, select 'Format Data Series', click the Paint bucket icon for 'Fill & Line', choose 'Marker', and adjust the 'Transparency' slider under the Fill options.
Can changing the series order fix the overlapping chart elements?
Sometimes. You can change the series order by right-clicking the chart, choosing 'Select Data', and using the Up and Down arrows on the legend entries. However, if Excel rendering bugs persist, using transparency or updating your software is the best alternative.
Will updating Excel fix chart rendering issues?
Yes, Microsoft frequently releases patch updates that resolve visual bugs like incorrect Z-ordering and overlapping elements in charts. Check for updates under File > Account > Update Options.




