Chart Value axis

[Damian]

The chart I just made has values of 10%, 20%,30%, 40% and 50%. How do I make
it only show the % sign next to the 50 at the top and not next to the other
numbers?

Thanks

damian

 

[Jon Peltier]

You'll have to plot numbers not percentages (percent time 100), then use a
custom number format:

[=50]0"%";0_%

The % in quotes means use a % character without using a percent format, the
_% means skip a blank space as wide as a 5 character, so the numbers line
up.

- Jon

 

[Damian]

Thanks!That really helped me out.

You'll have to plot numbers not percentages (percent time 100), then use a
custom number format:

[=50]0"%";0_%

The % in quotes means use a % character without using a percent format, the
_% means skip a blank space as wide as a 5 character, so the numbers line
up.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______

The chart I just made has values of 10%, 20%,30%, 40% and 50%. How do I
make
it only show the % sign next to the 50 at the top and not next to the
other
numbers?

Thanks

damian