LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
Enna
 
Posts: n/a
Default labels on the x-axis

Does anyone know how I can delete some of the numbers on the x-axis? I have
numbers ranging from 9 to 55 but only want to show 9-21, 25-31, 41 and
finally 55. I cannot just delete them on the worksheet because they are used
in the formulas making the chart as (=1/(A9+1)*100) (=1/(A10+1)*100) etc.
A9=9, A10=10 etc.
Also I want the x-axis labels to be centred under 9, 11, 13 and so on. How
do I do that?
Thank you
Enna
 
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
Excel2003: Axis labels are truncated David Burr Charts and Charting in Excel 2 October 31st 05 10:31 PM
Can tick mark labels be flipped about axis? [email protected] Charts and Charting in Excel 1 July 20th 05 05:03 PM
how to put x axis values in the chart instead of x axis labels Sinclair Charts and Charting in Excel 1 June 21st 05 11:04 AM
Align Clustered Column Chart Category Axis Labels Stephanie Charts and Charting in Excel 1 April 7th 05 03:21 PM
Labels on Chart with Negative Value Axis David F. Schrader Charts and Charting in Excel 6 December 17th 04 06:25 PM


All times are GMT +1. The time now is 07:46 AM.

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

About Us

"It's about Microsoft Excel"