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

  • Thread starter Thread starter JudyF
  • Start date Start date
J

JudyF

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 said:
On a stacked column chart, how do you put a percent sign on the top most
number on the vertical (value) axis?
Click to expand...

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]####"%";####" "
Click to expand...
 
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?
Click to expand...

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]####"%";####" "
Click to expand...
Click to expand...
 
Back
Top