+ Reply to Thread
Results 1 to 5 of 5

Secondary Axis Chart

  1. #1
    Registered User
    Join Date
    06-16-2010
    Location
    california, USA
    MS-Off Ver
    Excel 2003
    Posts
    3

    Secondary Axis Chart

    I am trying to understand how secondary axis's work. And I have the concept down and have created a secondary axis.

    (See attachment) My data points are all junk and I just put them there to get something on the chart.

    My goal: I want the secondary X axis to not be as tall as the primary.

    So if the primary has 1-10. I want the secondary to only be labeled to the 0-1. I want the secondary axis to be shorter than the primary. Seems like no matter what I do, it auto formats to expand to the top. I want there to be a bunch of space between the max secondary x axis max and the top of the chart. So the primary X will go from floor to roof of the chart, and the secondary will go from floor to 1 unit, and far from the roof.
    Attached Images Attached Images

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

    Re: Secondary Axis Chart

    The min/max scale values always go from bottom to top of plot area.

    If you only want it to reach part way up then you will need to set the maximum scale value to something larger.
    You can use a custom number format to mask the values displayed.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    06-16-2010
    Location
    california, USA
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Secondary Axis Chart

    Quote Originally Posted by Andy Pope View Post
    The min/max scale values always go from bottom to top of plot area.

    If you only want it to reach part way up then you will need to set the maximum scale value to something larger.
    You can use a custom number format to mask the values displayed.
    Close, Your suggestion got me one step closer, but I'm curious how you do a complex format like that in the "Number Format" section.

    The options are only <POSITIVE>;<NEGATIVE>;<ZERO>;<TEXT>

    in my case, i'd want an option to add IF(#>1), "". So display blank if greater than a number I set. This would allow me to set the limit at which my secondary X axis would display.

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

    Re: Secondary Axis Chart

    Fix the secondary value axis to a max of 9 and then use this custom number format.

    [White][>1]General;General

  5. #5
    Registered User
    Join Date
    06-16-2010
    Location
    california, USA
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Secondary Axis Chart

    Solved by you Thanks!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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