Adjusting display on Y axis to leave out some digits values.

[jonny]

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.

 

[Andy Pope]

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

 

[jonny]

Hi Andy
I dont think that will work because then it will reduce the values when they
do happen to be 10 to 0.1 etc. I would like to keep 10 as 10 when it is 10
but reduce 1000 to 10 when it is 1000.

 

[Andy Pope]

I think the only dynamic approach would be a VBA coded solution.

Cheers
Andy