A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Secondary Axis - Alignment of Dollar Values



 
 
Thread Tools Display Modes
  #1  
Old March 5th, 2010, 07:46 PM posted to microsoft.public.excel.charting
hans L
external usenet poster
 
Posts: 14
Default Secondary Axis - Alignment of Dollar Values

The dollar values for my secondary axis are left-aligned. I have tried
various number/accounting formats but can't get them to right-align. There
must be a way, right? Thanks in advance for your help.
  #2  
Old March 12th, 2010, 03:39 PM posted to microsoft.public.excel.charting
AdamV[_2_]
external usenet poster
 
Posts: 38
Default Secondary Axis - Alignment of Dollar Values

I assume you are trying to right align them because you have numbers of
varying length depending on size, eg 500, 1000, 10,000 etc.

Try using a custom number format for the axis such as:
[9999]$00,000;[999]$_00,000;$_0_0_0 000

(the smallest one is not perfect, the extra space for the zeroes and
comma don't work exactly, the single space helps and it should be 'fit
for purpose' even though not pixel precise.)

You don't say what version of Excel you have, so I can't give you a step
by step, but it sounds like you already know where to go to change
nunmber formats.

Adam

On 05/03/2010 18:46, hans L wrote:
The dollar values for my secondary axis are left-aligned. I have tried
various number/accounting formats but can't get them to right-align. There
must be a way, right? Thanks in advance for your help.

  #3  
Old March 15th, 2010, 06:32 PM posted to microsoft.public.excel.charting
hans L
external usenet poster
 
Posts: 14
Default Secondary Axis - Alignment of Dollar Values

I am using MS2007. I tried what you suggested but that doesn't work. I am
using the seconday axis to show cumulative numbers that range from $0 to
$150,000,000 in $10,000,000 increments.

"AdamV" wrote:

I assume you are trying to right align them because you have numbers of
varying length depending on size, eg 500, 1000, 10,000 etc.

Try using a custom number format for the axis such as:
[9999]$00,000;[999]$_00,000;$_0_0_0 000

(the smallest one is not perfect, the extra space for the zeroes and
comma don't work exactly, the single space helps and it should be 'fit
for purpose' even though not pixel precise.)

You don't say what version of Excel you have, so I can't give you a step
by step, but it sounds like you already know where to go to change
nunmber formats.

Adam

On 05/03/2010 18:46, hans L wrote:
The dollar values for my secondary axis are left-aligned. I have tried
various number/accounting formats but can't get them to right-align. There
must be a way, right? Thanks in advance for your help.

.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:01 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.