Chart & Visualization Issues

Fix Excel Scatter Plot Series Display Order & Overlapping Markers

Huma Ashraf ChHuma Ashraf Ch Nov 4, 2026 870 views

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.

How to Fix Excel Scatter Plot Series Display Order and Overlapping Markers
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 you start

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.

Solution 1Recommended

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.

1
Select the Data Series

Right-click the overlapping marker-only series in your scatter plot and choose 'Format Data Series' from the context menu.

2
Adjust Transparency

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.

3
Modify Marker Size or Line Width

Reduce the marker size of the overlapping series under 'Marker Options', or select the background series to increase its line width for better visibility.

Adjust Marker Transparency and Size
Visibility Improved: Adjusting transparency ensures that all data points are readable without relying on the strict series rendering order.

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. 1. Open Data in WPS: Launch WPS Spreadsheet and open your existing dataset or Excel file.
  2. 2. Insert a Scatter Chart: Highlight your data cells, navigate to the 'Insert' tab, click 'Chart', and choose the 'Scatter' option.
  3. 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.
Accurate rendering of multi-series scatter plots without overlapping bugs.Full compatibility with Microsoft Excel (.xlsx) formats and chart elements.Intuitive interface for easily adjusting marker transparency, lines, and Z-order.Lightweight installation with blazing fast performance for large datasets.
microsoft office alternative - wps office

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.