If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excell Chart-how do I change all the lines and points without cha. | ct | Charts and Charting | 3 | December 14th, 2004 12:54 AM |
Data points don't align to grid lines | Thomas | Charts and Charting | 1 | January 17th, 2004 06:16 PM |
Too many points on xy scatter plot! | Steve | Charts and Charting | 5 | December 31st, 2003 11:27 PM |
lines between data points | Steven M | Charts and Charting | 1 | December 16th, 2003 03:48 PM |
Scatter plot changes to line plot with data gaps | Jim | Charts and Charting | 14 | October 8th, 2003 05:10 PM |