+ Reply to Thread
Results 1 to 3 of 3

chart with two vertical axis scales

  1. 09-16-2015, 10:47 PM #1
    random379
    random379 is offline
    Registered User
    Join Date
    05-16-2005
    Posts
    33

    chart with two vertical axis scales

    I have a chart with 2 data series, series 1 plotting against the primary vertical axis, series 2 plotting against the secondary.
    I have added a third series and it plots against the secondary axis - how can I make it plot against the primary axis?

    Using excel 2007
    Thanks
    Reply With QuoteRegister To Reply
  2. 09-16-2015, 10:56 PM #2
    MrShorty
    MrShorty is offline
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,826

    Re: chart with two vertical axis scales

    Select the third data series -> Format selected data series -> series options -> select primary or secondary axis, as desired.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.
    Reply With QuoteRegister To Reply
  3. 09-16-2015, 11:02 PM #3
    random379
    random379 is offline
    Registered User
    Join Date
    05-16-2005
    Posts
    33

    Re: chart with two vertical axis scales

    Thanks Mr Shorty, I had a mental block and could not find how to actually select the series. Sorry for the bother.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Chart Axis with multiple scales
    By DiCaver in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-08-2015, 07:05 AM
  2. Vertical axis formatting: How do I keep chart Axis Y consistent for several charts
    By lukelucky in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-22-2015, 03:51 PM
  3. [SOLVED] How to draw a chart horizontal axis and vertical axis
    By kiany406 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 09-17-2012, 02:56 PM
  4. Chart using one column as vertical axis and others on horizontal axis!!!
    By nandhamnk in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 11-28-2007, 09:40 AM
  5. Two different x axis scales on same chart
    By Beeblebrox in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 11-16-2006, 11:56 AM
  6. Line chart with multiple scales/units along an axis...
    By JohanD in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 03-19-2006, 01:00 AM
  7. [SOLVED] "Broken" chart axis for data of different scales
    By Charlie in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 04-27-2005, 08:06 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1