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