charting problem

[Liz]

I'm running Office 2000. In my chart format axis tab
there's no pulldown menu for showing the axis in
thousands. How can I get the pulldown menu.

 

[Debra Dalgleish]

On the the Scale tab, there should be a dropdown list for 'Display
Units'. The default is 'None' -- change it to 'Thousands'

Another way to format the numbers on the axis is to create a custom
number format --

On the Number tab, select the Custom category.
In the text box, type: #,
Click OK

For more examples of custom number formats, see Jon
Peltier's web site:

http://peltiertech.com/Excel/NumberFormats.html

 

[Andy Pope]

Hi Liz,

What type of chart and which axis?

Cheers
Andy

 

[zebrowski]

-----Original Message-----
I'm running Office 2000. In my chart format axis tab
there's no pulldown menu for showing the axis in
thousands. How can I get the pulldown menu.
.
Did you try right clicking on the axis you want to

change. Click on Format, Axis, Scale. Change the major
and minor units.

 

[Jon Peltier]

There wouldn't be such a pulldown for a category axis on a line chart. Also it was
introduced in Excel 2000, so make sure you're not really using Excel 97.

Or you can follow Debra's sage advice.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______