Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 13th 08, 09:49 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2007
Posts: 5
Default 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?

  #2   Report Post  
Old January 14th 08, 12:27 AM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2007
Posts: 5
Default 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]####"%";####" "

  #3   Report Post  
Old January 14th 08, 05:14 AM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 6,582
Default 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]####"%";####" "





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can I make Column Chart use percent and show value lunarpc Charts and Charting in Excel 3 November 8th 07 07:14 PM
Percent two percentage in one chart Omar Excel Discussion (Misc queries) 0 July 31st 07 07:21 AM
number & percent column chart Max Charts and Charting in Excel 0 August 15th 06 12:45 AM
Formatting a number to look like a Percent without a percent sign David Iacoponi Excel Discussion (Misc queries) 2 September 15th 05 06:35 PM
Percent Data Label on 100% Stacked Column Chart PNichols Charts and Charting in Excel 2 June 13th 05 01:56 PM


All times are GMT +1. The time now is 12:30 AM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017