Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Apr 2001
    Posts
    304
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Question about Formatting Value Axis (Excel 2000 SP#)

    In the attached file, how do I format the Value Axis so that the value in millions ranges from 0-18, rather than 0-18,000,000 . I realize that I could truncate the values in my spreadsheet that the chart is pulling from and that would resolve the problem, but I would rather show the full amount in the spreadsheet and have the chart reflect "price in millions" Hope this make sense - thanks for the assistance. - Sat.

  2. #2
    3 Star Lounger
    Join Date
    Apr 2001
    Posts
    304
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Question about Formatting Value Axis (Excel 2000 SP#)

    I love it when I figure out my own questions. When formatting the Value access, selecting Millions from the Display units option (on the Scale tab) will do the trick.

Posting Permissions

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