Plot order of lines and points in XY scatterplots
 

In an Excel XY scatterplot I have plotted several data series. Some of
the data series are displayed as markers only with no line connecting
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 in
front of the markers. Changing the Series Order in the Format Data
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 of
another data series?

Thanks!


--
Elizabeth
------------------------------------------------------------------------
Elizabeth's Profile: http://www.highdots.com/forums/m1830
View this thread: http://www.highdots.com/forums/t3244185

Plot order of lines and points in XY scatterplots
 

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 wrote:
In an Excel XY scatterplot I have plotted several data series. Some of
the data series are displayed as markers only with no line connecting
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 in
front of the markers. Changing the Series Order in the Format Data
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 of
another data series?

Thanks!



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Plot order of lines and points in XY scatterplots
 

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


--
Elizabeth
------------------------------------------------------------------------
Elizabeth's Profile: http://www.highdots.com/forums/m1830
View this thread: http://www.highdots.com/forums/t3244185