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

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.

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

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.

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

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" wrote:

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.

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

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

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"jonny" wrote in message
...
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" wrote:

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.