Hi,

You have 2 options both are on the Format Axis dialog.
On the Number tab you could set a custom number format of 0, that is (zero
comma)

On the scale tab you could set the Display units to Thousands.

Cheers
Andy


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"jonny" wrote in message
...
I have a chart that I use to plot a number of diffferent data series.
Sometimes the numbers I am plotting are small e.g., within the range 0 to
100
and it looks good because the display (y axis) looks
0,10,20,30,40,50,60,70,80,90,100. Sometimes however the data I plot is
large
and it dispays 0,100000,20000,300000,400000 etc, which is hard on the eye.
Is
there any way that I can leave the display so it looks to the eye like it
is
0,10,20 even though it is really referring to 0,10000,20000 etc. (the user
will be able to tell from other info that the amounts are really
10000,20000
etc - so I am not worried about the user thinking it is really 10 and not
10000.

I am not looking to reduce/change the actual numbers being plotted - just
to adjust the DISPLAY so it is easier on the eye so that 10 displays as 10
but 10,000 also disaplys as 10 (in a higher scale environment). Hope I was
able to explain the above clearly.