Chart Value axis
 

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

Chart Value axis
 

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
_______


"Damian" wrote in message
...
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

Chart Value axis
 

Thanks!That really helped me out.

"Jon Peltier" wrote:

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
_______


"Damian" wrote in message
...
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