+ Reply to Thread
Results 1 to 5 of 5

Arrange the layering of series displayed in a plot

  1. #1
    Registered User
    Join Date
    07-26-2013
    Location
    Massachusetts
    MS-Off Ver
    Excel 2010
    Posts
    47

    Arrange the layering of series displayed in a plot

    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.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    04-07-2014
    Location
    Port Talbot, Wales
    MS-Off Ver
    Excel 2007
    Posts
    54

    Re: Arrange the layering of series displayed in a plot

    Hi SaraLynne,

    Please try the attached to see if it matches your requirments

    Regards,

    Cobwebs
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    07-26-2013
    Location
    Massachusetts
    MS-Off Ver
    Excel 2010
    Posts
    47

    Re: Arrange the layering of series displayed in a plot

    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?

  4. #4
    Registered User
    Join Date
    04-07-2014
    Location
    Port Talbot, Wales
    MS-Off Ver
    Excel 2007
    Posts
    54

    Re: Arrange the layering of series displayed in a plot

    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)

  5. #5
    Registered User
    Join Date
    07-26-2013
    Location
    Massachusetts
    MS-Off Ver
    Excel 2010
    Posts
    47

    Re: Arrange the layering of series displayed in a plot

    Genius! Thank you so much!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 2
    Last Post: 11-11-2013, 05:37 PM
  2. [SOLVED] Plot where blank fields are ignored, not displayed.
    By kbka in forum Excel General
    Replies: 4
    Last Post: 07-17-2012, 11:23 AM
  3. [SOLVED] using checkboxes to plot certain data series on one plot
    By chemeng1T3 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-10-2012, 07:08 AM
  4. [SOLVED] how do I plot a data series against two series
    By Frustrated in Sydney in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 02-16-2006, 12:25 AM
  5. [SOLVED] chart data series -- plot a table as a single series
    By hjc in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 09-20-2005, 01:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1