charting problem

  • Thread starter Thread starter Liz
  • Start date Start date
L

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.
 
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
 
-----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
Click to expand...
change. Click on Format, Axis, Scale. Change the major
and minor units.
 
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/
_______
 
Back
Top