Excel Charting Facility

Discussion in 'Mac Basics and Help' started by Shaun.P, Sep 22, 2005.

  1. Shaun.P macrumors 68000

    Shaun.P

    Joined:
    Jul 14, 2003
    Location:
    Omicron Persei 8
    #1
    Hey, I would like to create a chart like this: http://forums.macrumors.com/attachment.php?attachmentid=27585 in excel. However when I try to do it, the y-axis always begins at 0. I would like to set it to my own value so it shows in more detail, i.e. 100 to 200 shows more detail if no values in the y-axis go below 100.

    Any help would be greatly appreciated.
     
  2. MacDawg macrumors P6

    MacDawg

    Joined:
    Mar 20, 2004
    Location:
    "Between the Hedges"
    #2
    Control click the axis and select "format axis"
    Select the "scale" tab and set the minimum

    WOF, WOF - DAWG [​IMG]
     
  3. clayj macrumors 604

    clayj

    Joined:
    Jan 14, 2005
    Location:
    visiting from downstream
    #3
    In case you're interested, here is how axis limits are determined in charts in Excel.

    P.S.: I wrote this article. :)
     
  4. Shaun.P thread starter macrumors 68000

    Shaun.P

    Joined:
    Jul 14, 2003
    Location:
    Omicron Persei 8
    #4
    Thanks for your help!

    Do you work for Microsoft?
     
  5. MacDawg macrumors P6

    MacDawg

    Joined:
    Mar 20, 2004
    Location:
    "Between the Hedges"
    #5
    No

    Oh, you mean clayj :eek:

    WOF WOF – DAWG [​IMG]
     

Share This Page