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