+ Reply to Thread
Results 1 to 5 of 5

Arrange the layering of series displayed in a plot

Hybrid View

  1. #1
    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)

  2. #2
    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