Try this:
[=70000]####"%";####_%
The underscore followed by a character tells Excel to leave a blank space as
wide as the character.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -
http://PeltierTech.com
_______
"JudyF" wrote in message
...
I got the percent sign on the top number, but like you said it doesn't line
the numbers up. I tried the second formula and it didn't work. Is there
any
other way to make the numbers align?
"Gklass" wrote:
On Jan 13, 3:49 pm, JudyF wrote:
On a stacked column chart, how do you put a percent sign on the top
most
number on the vertical (value) axis?
Use a custom number format, say if the max value was 70:
[=70]##"%";##
The only problem with that is that it doesn't align the column of
numbers well, to fix that add a couple spaces after the others.:
[=70000]####"%";####" "