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: 67
Default Excel 2007 text labels in category axis - missing labels

I have 2 sets of about 7000 data points in a line chart and have a column of
data
with sporadic labels at selected positions. In Excel 2007, selecting
this range (7000 rows, say 30 if which have a label) as the category labels
and
setting the label spacing as one, I can only get the very first label to show
on the chart. By playing around with the label spacing, I can sometimes get
the first 2 labels to display (but cannot understand why) but cannot get all
my labels to display as expected (and as they would under previous versions
of Excel). Can anyone tell me how to get all my labels to display (at their
appropriate positions)? The behaviour remains the same whether the range
contains sporadic text data or formulae whic resultmaninly in blanks with a
few resulting in text. (I have some sets of time data, but for a few months
in different years, which I want to plot on a single chart, not using a time
axis as this would have most of the space dedicated to the dates with no
data... I have used a formula to lablel only the 1 and 15 of the month at
midnight and these are the labes I would like to get on my category axis.)
Many thanks and best wishes, Boris,

 
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
Category (X) Axis Labels not found in Excel 2003 vrk1 Charts and Charting in Excel 2 March 12th 08 08:11 PM
Missing Axis Category Labels CruisJR Charts and Charting in Excel 1 March 29th 07 06:42 PM
Category Labels(X) axis on a chart: Ali Excel Worksheet Functions 2 January 19th 06 11:53 AM
alignment of y axis category labels philcud Charts and Charting in Excel 4 August 9th 05 07:44 PM
Bar chart & Category (x) axis labels Airi A. Charts and Charting in Excel 0 March 15th 05 03:09 PM


All times are GMT +1. The time now is 02:29 PM.

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"