On a stacked column chart, how do you put a percent sign on the top most
number on the vertical (value) axis?

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]####"%";####" "

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]####"%";####" "