Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Format Axis labels: change 20,000,000 to 20 MM
I have a graph that is driven off numeric data in a pivot table. The
labels on the X and Y axis are large numbers (e.g. 20,000,000) and I'd like to change the format to shorten them (e.g. to 20 MM), thus gaining myself some additional room to display data. If this can be done, how can it be done? Thanks in advance Thomas Philips |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Format Axis labels: change 20,000,000 to 20 MM
Right click on the Axis and select Format Axis. On the Scale tab select
Millions under Display Units. That should be close -- HTH... Jim Thomlinson " wrote: I have a graph that is driven off numeric data in a pivot table. The labels on the X and Y axis are large numbers (e.g. 20,000,000) and I'd like to change the format to shorten them (e.g. to 20 MM), thus gaining myself some additional room to display data. If this can be done, how can it be done? Thanks in advance Thomas Philips |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Format Axis labels: change 20,000,000 to 20 MM
Works like a charm -thanks a mill.
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change Horizontal Axis Labels | Charts and Charting in Excel | |||
How to change labels on axis? | Charts and Charting in Excel | |||
change the position of X-axis labels | Charts and Charting in Excel | |||
how to change axis labels to text? | Charts and Charting in Excel | |||
Can't change x-axis labels | Charts and Charting in Excel |