Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Category (X) Axis Labels not found in Excel 2003 | Charts and Charting in Excel | |||
Missing Axis Category Labels | Charts and Charting in Excel | |||
Category Labels(X) axis on a chart: | Excel Worksheet Functions | |||
alignment of y axis category labels | Charts and Charting in Excel | |||
Bar chart & Category (x) axis labels | Charts and Charting in Excel |