Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 3rd 08, 03:32 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2007
Posts: 67
Default Line chart categoray axis labels issue - Excel 2007

Hi,
I have two problems (bugs perhaps) that I need o find a way to work around
in Excel 2007. They both concern the category (x) axis (text) labels in line
charts. I normally shy away from line charts entirely but, in the given
instance I need to use them.

First question: when you first create the line chart, and when you set the
labels for the category axis, Excel automatically rotates the labels to get
them to fit as well as possible. However, if you go in to the Format Axis
AlignmentCustom Angle box and enter a value, I can find no way of reenabling
Excels automatic selection of rotation. Even deleting the axis, and then
recreating it, does not reactivate this automatic feature. Previous version
of Excel had a radio button for "automatic" but I cannot find this in Excel
2007... Is there any way of reenabling the automatic rotation behaviour?

Second (more serious) question. I am using a line series with text category
axis to plot some time data for different years. As I am only using 3 months
for each year, I do not want to use a time series (most of the graph space is
then occupied by periods with no data). When I select my x axis label range,
everything is OK if this range is fully occupied: by selecting appropriate
entries for Format AxisAxis OptionsInterval between tick marks and
....specify interval unit, I can get appropriately distributed ticks (each
representing, say, 1 week) and adequately spaced labels. However, I wanted
more control over the tick labels so I have created a further range with a
formula which results in a blank unless the original label is for the first
or 15th of a month at (near) midnight. So far so good, but when I make the
line chart refer to this range, which is predominantly blank (""), the chart
now shows only the first label or, by playing with the ...specify interval
unit setting, I can perhaps get it to show the first two tick labels but
under no circumstances all of them (there are about 30 in total, fairly
evenly distributed along the range but corresponding to useful dates). In
previous versions of Excel (I have just tried to make sure that this is the
case), it would work well once this new range is selected and the tick label
spacing set to 1 but not in Excel 2007... I have even tried copying the range
with the formulae to a new range and pasting it as values only (no
difference) and even going in and deleting all the blank cells in the range
between consecutive labels but nothing changes...

Is this behaviour common and is there a work around???

Any help very gratefully received as I have sort of hit a brick wall with
this and, other than going back to Excel 2003m which I would for various
reasons be loathed to do, cannot think of anything else to try...

Many thanks and best wishes, Boris.


  #2   Report Post  
Old December 4th 08, 03:14 AM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2008
Posts: 20
Default Line chart categoray axis labels issue - Excel 2007

Hi,

Hate to be a party pooper, but could you simplify this verbose post, you
generally will find that if the post is too long, you won't get an answer.



"Boris" wrote:

Hi,
I have two problems (bugs perhaps) that I need o find a way to work around
in Excel 2007. They both concern the category (x) axis (text) labels in line
charts. I normally shy away from line charts entirely but, in the given
instance I need to use them.

First question: when you first create the line chart, and when you set the
labels for the category axis, Excel automatically rotates the labels to get
them to fit as well as possible. However, if you go in to the Format Axis
AlignmentCustom Angle box and enter a value, I can find no way of reenabling
Excels automatic selection of rotation. Even deleting the axis, and then
recreating it, does not reactivate this automatic feature. Previous version
of Excel had a radio button for "automatic" but I cannot find this in Excel
2007... Is there any way of reenabling the automatic rotation behaviour?

Second (more serious) question. I am using a line series with text category
axis to plot some time data for different years. As I am only using 3 months
for each year, I do not want to use a time series (most of the graph space is
then occupied by periods with no data). When I select my x axis label range,
everything is OK if this range is fully occupied: by selecting appropriate
entries for Format AxisAxis OptionsInterval between tick marks and
...specify interval unit, I can get appropriately distributed ticks (each
representing, say, 1 week) and adequately spaced labels. However, I wanted
more control over the tick labels so I have created a further range with a
formula which results in a blank unless the original label is for the first
or 15th of a month at (near) midnight. So far so good, but when I make the
line chart refer to this range, which is predominantly blank (""), the chart
now shows only the first label or, by playing with the ...specify interval
unit setting, I can perhaps get it to show the first two tick labels but
under no circumstances all of them (there are about 30 in total, fairly
evenly distributed along the range but corresponding to useful dates). In
previous versions of Excel (I have just tried to make sure that this is the
case), it would work well once this new range is selected and the tick label
spacing set to 1 but not in Excel 2007... I have even tried copying the range
with the formulae to a new range and pasting it as values only (no
difference) and even going in and deleting all the blank cells in the range
between consecutive labels but nothing changes...

Is this behaviour common and is there a work around???

Any help very gratefully received as I have sort of hit a brick wall with
this and, other than going back to Excel 2003m which I would for various
reasons be loathed to do, cannot think of anything else to try...

Many thanks and best wishes, Boris.

  #3   Report Post  
Old December 4th 08, 05:55 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2007
Posts: 67
Default Line chart categoray axis labels issue - Excel 2007

Thanks Cheers, here goes... (I will also submit the wording below as 2 new
queries...

1/ Is there any way in Excel 2007 of re-enabling the automatic (best fit)
rotation feature on category values text axes after you have entered a custom
angle (the simple checkbox that existed in previous versions is no longer
there and the program will not allow you to remove a custom angle completely
once one has been set - only to change it)?

2/ I have about 7000 data points in a line series and have a column of data
with sporadic labels and selected positions. Again, in Excel 2007, selecting
his range (7000 rows, 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)?

Many thanks.
Best wishes, Boris.


"Cheers," wrote:

Hi,

Hate to be a party pooper, but could you simplify this verbose post, you
generally will find that if the post is too long, you won't get an answer.



"Boris" wrote:

Hi,
I have two problems (bugs perhaps) that I need o find a way to work around
in Excel 2007. They both concern the category (x) axis (text) labels in line
charts. I normally shy away from line charts entirely but, in the given
instance I need to use them.

First question: when you first create the line chart, and when you set the
labels for the category axis, Excel automatically rotates the labels to get
them to fit as well as possible. However, if you go in to the Format Axis
AlignmentCustom Angle box and enter a value, I can find no way of reenabling
Excels automatic selection of rotation. Even deleting the axis, and then
recreating it, does not reactivate this automatic feature. Previous version
of Excel had a radio button for "automatic" but I cannot find this in Excel
2007... Is there any way of reenabling the automatic rotation behaviour?

Second (more serious) question. I am using a line series with text category
axis to plot some time data for different years. As I am only using 3 months
for each year, I do not want to use a time series (most of the graph space is
then occupied by periods with no data). When I select my x axis label range,
everything is OK if this range is fully occupied: by selecting appropriate
entries for Format AxisAxis OptionsInterval between tick marks and
...specify interval unit, I can get appropriately distributed ticks (each
representing, say, 1 week) and adequately spaced labels. However, I wanted
more control over the tick labels so I have created a further range with a
formula which results in a blank unless the original label is for the first
or 15th of a month at (near) midnight. So far so good, but when I make the
line chart refer to this range, which is predominantly blank (""), the chart
now shows only the first label or, by playing with the ...specify interval
unit setting, I can perhaps get it to show the first two tick labels but
under no circumstances all of them (there are about 30 in total, fairly
evenly distributed along the range but corresponding to useful dates). In
previous versions of Excel (I have just tried to make sure that this is the
case), it would work well once this new range is selected and the tick label
spacing set to 1 but not in Excel 2007... I have even tried copying the range
with the formulae to a new range and pasting it as values only (no
difference) and even going in and deleting all the blank cells in the range
between consecutive labels but nothing changes...

Is this behaviour common and is there a work around???

Any help very gratefully received as I have sort of hit a brick wall with
this and, other than going back to Excel 2003m which I would for various
reasons be loathed to do, cannot think of anything else to try...

Many thanks and best wishes, Boris.



Reply
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
Excel 2007 - change interval between labels on X axis artemis Charts and Charting in Excel 3 June 19th 08 01:28 PM
Axis Labels Cut off in Excel Chart EricT Charts and Charting in Excel 1 March 8th 07 12:58 PM
Combination chart: primary data labels obscure line series on secondary axis Uhl Charts and Charting in Excel 3 December 12th 06 09:52 PM
Sub-Categories for X-axis labels, line on bar chart? cfagan Charts and Charting in Excel 1 March 3rd 06 06:01 PM
x axis labels/scale move to middle of chart w/neg & pos line cht rak Excel Worksheet Functions 1 August 30th 05 03:51 PM


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

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017