Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    Brooklyn, New York, USA
    Posts
    200
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Formulaes used to change the Y axis (Excel)

    I used to know a number of formulae used within graphing to format the number on the y axis, yielding a variety of results: making the font of the top most value a different color; breaking the scale so that the top most 1 or 2 numbers read differently, and so one. Is anyone familiar with these and can post them? Thank you!
    <img src=/S/crossfingers.gif border=0 alt=crossfingers width=17 height=16>

  2. #2
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Springfield, Ohio, USA
    Posts
    2,136
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Formulaes used to change the Y axis (Excel)

    Naomi, are you thinking of conditional formating? It's under the Format menu. Unfortunately as the attached worksheet shows, these format changes are not reflected in a chart based on the data. I think that you would have to use VBA to copy the data formating to the chart. HTH --Sam
    Attached Files Attached Files
    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

  3. #3
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    Brooklyn, New York, USA
    Posts
    200
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: Formulaes used to change the Y axis (Excel)

    Thanks SammyB,
    conditional formatting is not what I'm thinking of, especially as it seems only to apply to cell values and not values as charted. If you click on the value axis of any chart to format it and go to number formatting, custom, you'll see that many formats are broken into 2 parts separated by parentheses, or commas, the first part being the format for positive numbers, the second the negative. I know that Excel accepts a maximum of three, the third possibly being the highest value or highest set of values. Exactly how those formulas are written is what I'm after. Anyone have an idea?

  4. #4
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Springfield, Ohio, USA
    Posts
    2,136
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Formulaes used to change the Y axis (Excel)

    OK, now I understand what you want. As you have already discovered, these are called custom number formats. First, check out the help file. If you are using XL2000, then type "Custom Number Format" in the Answer Wizard tab of Excel help, and choose "Create a custom number format." There you will learn that these formats consist of four parts: a code for negative, a code for zero, a code for positive values, and a code for text. The code for each part is separated with a semicolon. However, notice that in the example there is a
    Attached Files Attached Files
    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

  5. #5
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    Brooklyn, New York, USA
    Posts
    200
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: Formulaes used to change the Y axis (Excel)

    Thank you! This should do it. Last time I tried, Excel kept defaulting to some screwy obstinate useless format, but with your examples I hope I can plow ahead. <img src=/S/chatter.gif border=0 alt=chatter width=38 height=16>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •