+ Reply to Thread
Results 1 to 4 of 4

Pad axis numbers so that chart width is consistent throughout a range of charts.

  1. #1
    Registered User
    Join Date
    06-28-2013
    Location
    Sweden
    MS-Off Ver
    Excel 2010
    Posts
    2

    Pad axis numbers so that chart width is consistent throughout a range of charts.

    Like the title says.

    Is it possible? If so, how?

    An example of why this is useful:

    Lets say you have two scatter charts 'a' and 'b'. On chart 'a' the y-axis has numbers going from 0-10. Chart 'b' y-axis goes from 100-1000.

    Using the default axis options, that means that chart 'b' will have a wider y-axis, making the 'b' chart smaller compared to chart 'a' (given that 'a' and 'b' has the same total chart width). I want to pad the numbers in the y-axis so that both chart areas get the same width.

    Does that make sense?

    Any help much appreciated.

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,819

    Re: Pad axis numbers so that chart width is consistent throughout a range of charts.

    Try using the "?" in your number format code for the y axis.
    http://office.microsoft.com/en-us/ex...679.aspx?CTT=1

    This is similar to a suggestion made in this thread: http://www.excelforum.com/excel-char...73#post2949073
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Pad axis numbers so that chart width is consistent throughout a range of charts.

    Maybe format the y axis as ???0

    EDIT: Slow out of the block ...
    Last edited by shg; 06-28-2013 at 01:45 PM.
    Entia non sunt multiplicanda sine necessitate

  4. #4
    Registered User
    Join Date
    06-28-2013
    Location
    Sweden
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Pad axis numbers so that chart width is consistent throughout a range of charts.

    Ah, nice!

    Thank you guys n gals!

+ 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