Prev: Showing a different set of data in a chart
Next: How can I add a chart on my user form ?
From: Risky Dave on 23 Feb 2010 06:11
Hi,

I have a simple column chart that uses millions of units on its Y axis and
puts a label above each column showing the exact value. At the moment the Y
axis shos all the trailing zeros behind each million value, somethiong like:

40000000
36524102
35000000 x
.. x
.. x
.. x
5000000 x
colummns here

What I would like to show is the Y axis values without the trailing zeros
but the data label in full. I seem to be able to do one or the other but not
both.

Hope this makes sense!

This is in Office 2003.

TIA

Dave
From: Fowmy on 23 Feb 2010 06:54
you can create a secondary axis and hide with same data series you already use. Then, display primary verticle axis values in millions and do not add labels but add data lables to 2nd axis with full number format. this is because your 2nd data series is behind the 1st

---
frmsrcurl: http://msgroups.net/microsoft.public.excel.charting/Making-Data-and-Axis-Labels-Different
From: Jon Peltier on 23 Feb 2010 14:29
Use a custom number format that removes the excess zeros.

To show all digits, use a number format like '0' (entered without the
quotes).

Add a comma after the format to drop three zeros:

'0,' shows 1000 as 1
'0.0,' shows 1200 as 1.2

Add another comma for each block of three zeros you want to suppress.

'0,,' shows 14,000,000 as 14
'0.00,,' shows 12,340,000 as 12.34

To use a suffix to indicate millions:

'0,,"M"' shows 14,000,000 as 14M
'0.00,,"M"' shows 12,340,000 as 12.34M
Don't enter the single quotes, but do enter the double quotes.

More on number formats:

Number Formats in Excel
http://peltiertech.com/Excel/NumberFormats.html

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
774-275-0064
http://peltiertech.com/


On 2/23/2010 6:11 AM, Risky Dave wrote:
> Hi,
>
> I have a simple column chart that uses millions of units on its Y axis and
> puts a label above each column showing the exact value. At the moment the Y
> axis shos all the trailing zeros behind each million value, somethiong like:
>
> 40000000
> 36524102
> 35000000 x
> . x
> . x
> . x
> 5000000 x
> colummns here
>
> What I would like to show is the Y axis values without the trailing zeros
> but the data label in full. I seem to be able to do one or the other but not
> both.
>
> Hope this makes sense!
>
> This is in Office 2003.
>
> TIA
>
> Dave
 | 
Pages: 1
Prev: Showing a different set of data in a chart
Next: How can I add a chart on my user form ?