Changing Millions to Thousands

[Wendy]

Yesterday while poking and clicking around a graph I had created, I found a
box where you could change your number from millions to thousands. Today, I
cant find it. In my Y axis's I have my number set in millions, and I want to
change those numbers to thousands. It wasnt in the "Format Axix" box either.
What and where is this box that has this feature?

ps.. I love excel... 03 is great, and 07 is even better. The more I learn,
the more I become addicted.

 

[Shane Devenshire]

Hi,

Assuming you are using 2003 or earlier -
1. Double-click the Y-axis and choose the Scale tab
2. Open the Display Units drop down

If this helps, please click the Yes button

Cheers,
Shane Devenshire

 

[Wendy]

Cool, thank you so much! Absolutely will click YES!

Cheers!

 

[Mike Middleton]

Wendy -

In Excel 2007, select the axis and right-click, or directly right-click the
axis, from the menu choose Format Axis | Axis Options | Display units, and
select from the drop-down list.

In Excel 2003, choose Format Axis | Scale | Display units.

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel