Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    May 2002
    Location
    Midland, Michigan, USA
    Posts
    133
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formatting Data Ranges on Charts (Excel 2000)

    It doesn't look like the attachment made it with your post. Could you re-post?

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Formatting Data Ranges on Charts (Excel 2000)

    Depending on your data, you could try formatting the value axis with a logarithmic scale.
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    Star Lounger
    Join Date
    Jun 2002
    Location
    Worthington, Ohio, USA
    Posts
    66
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Formatting Data Ranges on Charts (Excel 2000)

    I understand there is a way to show data in proportion to each other when the actual data is way off. For example, if you have 12 months and in January and July, sales are $5billion dollars but in April, May and Sept, sales are only $2 million. On a chart, you can set the values such that your max is $5 billion, your minimum to 0 (so that you show the really low months) and then your major unit in increments of $100,000, or whatever. However, the values format very small and the graphs are really large. So much that you can barely see your lowest values. I've seen where the values are incremented by 500 and then jump all of the sudden to an extrordinarily high value to support the higher numbers. Some graphs even have jagged edges at the very top to show that there will be a jump in the values. Anyone that can help, I'd appreciate it.

    Attached is a problem we're having and can barely see the lower number
    Thanks!
    Attached Files Attached Files

  4. #4
    2 Star Lounger
    Join Date
    May 2002
    Location
    Midland, Michigan, USA
    Posts
    133
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formatting Data Ranges on Charts (Excel 2000)

    You can take a look here. I believe it does what you want.

    Good luck!

Posting Permissions

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