I have a plot of a large data series (>43000 points) and I want to display a smaller data series on top of it, but I can't find a way to arrange the order that the data series are displayed. It automatically places the large data series on top, even if I arrange their order in the "Select Data" menu.
I'm running Excel 2010 and it's an x-y scatter plot.
I've attached an example spreadsheet. I want Series 2, the line, to display on top of Series 1.
Hi SaraLynne,
Please try the attached to see if it matches your requirments
Regards,
Cobwebs
Yes, that's exactly what I'm trying to do! Thank you! How did you do it? Am I just not seeing a menu option?
Right click the line and under "Series Options" select "Secondary Axis" then just hide the Axis Titles. Also click on "Line Style" and increase the width to whatever you fancy
Forgot to add that before you hide the axis, ensure both axis are set to the same scale!!!
Hope this helps. If so, please click the * to add to Reputation
Alba gu brath
Cobwebs, Alba Gu Brath (Scotland Forever)
Genius! Thank you so much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks