PC Review
Forums
Newsgroups
Microsoft Excel
Microsoft Excel Charting
Plotted line to show OVER plotted points
Forums
Newsgroups
Microsoft Excel
Microsoft Excel Charting
Plotted line to show OVER plotted points
![]() |
Plotted line to show OVER plotted points |
|
|
Thread Tools | Rate Thread |
|
|
#1 |
|
Guest
Posts: n/a
|
I have two separate plots on one chart. A set of points (blobs) and separate fitted line. However the line is 'engulfed' by the points. have tried 'series order' - but it doesn't stop the points appearing o top of the line How do I ensure the line properly displays on top of the points ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages directly from http://www.ExcelForum.com |
|
|
|
#2 |
|
Guest
Posts: n/a
|
This works if both series are Scatter. Plot the points-only series on
the primary axis, and the line-only series on the secondary. The lines connecting the second series will overlie the points of the first. - Jon ------- Jon Peltier, Microsoft Excel MVP http://www.geocities.com/jonpeltier/Excel/index.html _______ andrefrancis wrote: > I have two separate plots on one chart. A set of points (blobs) and a > separate fitted line. However the line is 'engulfed' by the points. I > have tried 'series order' - but it doesn't stop the points appearing on > top of the line > > How do I ensure the line properly displays on top of the points? > > > ------------------------------------------------ > ~~ Message posted from http://www.ExcelTip.com/ > ~~View and post usenet messages directly from http://www.ExcelForum.com/ > |
|
![]() |
|
| Thread Tools | |
| Rate This Thread | |
|
|

Main Page 

