LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
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
 
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
data table labels for x axis Christy Charts and Charting in Excel 1 July 16th 09 03:58 AM
Nested Data Axis Labels ratpha Charts and Charting in Excel 0 May 18th 09 01:05 PM
Data labels along below x axis when y axis has negative values Andrew Charts and Charting in Excel 1 July 3rd 08 08:36 PM
data series and axis labels cdwinlib Charts and Charting in Excel 2 May 11th 07 12:17 PM
Data labels: Making the value currency & use % in a chart? AKO Charts and Charting in Excel 1 August 2nd 05 09:47 PM


All times are GMT +1. The time now is 08:34 AM.

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

About Us

"It's about Microsoft Excel"