Plot order of lines and points in XY scatterplots

[Elizabeth]

In an Excel XY scatterplot I have plotted several data series. Some o
the data series are displayed as markers only with no line connectin
them, others I turn off the marker and show only the connecting line.
The lines plot behind the markers. I would like the lines to plot i
front of the markers. Changing the Series Order in the Format Dat
Series dialog box seems to have no effect on this.

How do I plot the line of one data series in front of the markers o
another data series?

Thanks

 

[Andy Pope]

Hi,

To make the lines appear infront of the data markers move the data
series to the secondary axis. Double click the series and on the Axis
tab choose Secondary axis.

Cheers
Andy

 

[Elizabeth]

Thank you and bless your soul! It works exactly right!
--Elizabet