Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Chart - Secondary Y-axis with different values/scale | Charts and Charting in Excel | |||
Secondary Axis Values Disappear | Charts and Charting in Excel | |||
Dollar format alignment | Excel Discussion (Misc queries) | |||
On a secondary Y-axis, scale values are repeated: 1, 1, 2, 2. | Charts and Charting in Excel | |||
Secondary Axis Annual Units sold on 1 Y Axis - Dollar Volume on another | Charts and Charting in Excel |