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
|
|||
|
|||
layering of series in XY plot
Howdy,
I'm plotting a series of xy points on an XY Chart. I've also added a '1:1' trend line to the plot as a second series with the markers turned off and 'line' turned on. However the points plot themselves over-top of the line, regardless of how I order the series. Is there a way around this? Jim (using XL 2000) |
#2
|
|||
|
|||
Hi Jim,
See my "Shared Solution" post above. You might find it helpful. Good luck, LeAnne Jim wrote: Howdy, I'm plotting a series of xy points on an XY Chart. I've also added a '1:1' trend line to the plot as a second series with the markers turned off and 'line' turned on. However the points plot themselves over-top of the line, regardless of how I order the series. Is there a way around this? Jim (using XL 2000) |
#3
|
|||
|
|||
Jim -
I think what you want is different from LeAnne's suggestion. Do you want the line to lie on top of the points, blocking them from view? When Excel draws a line chart, all the lines are drawn underneath all the markers. However, if the markers are plotted on the primary axis, and the line is plotted on the secondary axis, the line will be drawn in front of the markers. Make the chart with all your series, then select the line series, press CTRL+1 to format it, and on the Axis tab, choose Secondary and click OK. Since you don't need the secondary axis, choose Chart Options from the Chart menu, click on the Axis tab, and uncheck any secondary axes. The series will remain in separate chart axis groups, even though they use the same axes. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Jim wrote: Howdy, I'm plotting a series of xy points on an XY Chart. I've also added a '1:1' trend line to the plot as a second series with the markers turned off and 'line' turned on. However the points plot themselves over-top of the line, regardless of how I order the series. Is there a way around this? Jim (using XL 2000) |
#4
|
|||
|
|||
Thanks to both Jon and LeAnne ... both worked. I ended up using the trend
line option. The line I needed to plot was just a 1:1 line (very simple) and made a second series (not plotted) that had the used the x-variable from the point-series, but plotted against itself (hence 1:1). I then use this non-plotted series as the basis for a linear trend line. Like I mentioned, this was fine since the line I needed to plot was essentially a trend line anyway (just not a trend for the plotted point series), but I was wondering how it could be done if I had to plot a complex (ie. second series) line. Jon's response seems to be the answer. Thanks again, Jim "Jim" wrote in message ... Howdy, I'm plotting a series of xy points on an XY Chart. I've also added a '1:1' trend line to the plot as a second series with the markers turned off and 'line' turned on. However the points plot themselves over-top of the line, regardless of how I order the series. Is there a way around this? Jim (using XL 2000) |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Ineffective change of plot order in series formula | Jon Peltier | Charts and Charting | 3 | May 30th, 2004 02:15 AM |
Plot series from Code | Tushar Mehta | Charts and Charting | 1 | March 30th, 2004 07:29 PM |
Chart series split over more than 1 line - dont plot #n/a | allycat898 | Charts and Charting | 2 | March 22nd, 2004 10:11 AM |
Scatter plot changes to line plot with data gaps | Jim | Charts and Charting | 14 | October 8th, 2003 05:10 PM |
Multiple series with different x-values on one scatter plot | NKelly | Charts and Charting | 4 | October 2nd, 2003 05:31 PM |