On a column chart, how do you put a percent sign on the top most .
On a stacked column chart, how do you put a percent sign on the top most
number on the vertical (value) axis? |
On a column chart, how do you put a percent sign on the top mo
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]####"%";####" " |
On a column chart, how do you put a percent sign on the top mo
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]####"%";####" " |
All times are GMT +1. The time now is 05:12 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com