View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Risky Dave Risky Dave is offline
external usenet poster
 
Posts: 161
Default Making Data and Axis Labels Different

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