+ Reply to Thread
Results 1 to 3 of 3

Need to plot one series on top of another

  1. #1
    Registered User
    Join Date
    05-08-2012
    Location
    Little Rock, AR
    MS-Off Ver
    Excel 2007
    Posts
    2

    Need to plot one series on top of another

    In the attached file, I have several X-Y scatter plots, each of which is a plot of two series. One series is plotted with green X's and no line, while the other series is plotted as a blue line with no markers. I can't get the blue line to plot on top of the green X's. I tried changing the order of the series under the "Select Data" menu, but it still puts the green X's on top of the blue line. Can someone tell me how to get the series with the blue line to plot on top of the green X's? (i.e., I want the blue line to always be visible, even when the green X's have similar values). Thanks!
    Attached Files Attached Files

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,482

    Re: Need to plot one series on top of another

    Interesting quirk. I would have expected changing the plot order to bring the blue line to the forefront.

    2 choices. Move the blue line to the secondary axis and then delete the secondary value axis.

    Or apply line colour to the green cross series and set the line transparency to 99%
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    05-08-2012
    Location
    Little Rock, AR
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Need to plot one series on top of another

    Great idea to plot the predicted data (the blue line) on the secondary Y axis. I did that and used a custom format to hide the labels for the secondary Y axis (see attached). It works perfectly. Thanks for your help.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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