On a column chart, how do you put a percent sign on the top most .

J

JudyF

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

JudyF

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

Jon Peltier

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top