software

I have a spread sheet with the following three series:

Series 1 (column 1) is A:2 through A:25, formatted date, values Jan 2005
through Dec 2005

Series 2 (column 2) is B:2 through B:25, fomatted number, values integers

Series 3 (column 3) is C:2 through C:25, formatted number, values integers

I select these three columns and then invoke the chart wizard to make a line
chart based on them.

Series 2 (column 2) is assigned to one line of the chart. Series 3 (column
3) is assigned to another line. Series 1 (column 1), the list of dates, is
assigned to the quot;Category (X) axis labelquot;.

When Excel creates the chart, the list of dates beneath the X axis is
extended from Dec 2005 all the way out August 2006, even though the list ends
with Dec 2005 and there are no values for these dates.

Anybody know what's going on? Thanks.Hi Michael:
The x-axis scale range is something of a mystery; I nearly always have to
use Format | Axis, open Scale tab and change Min and Max values.
But I wonder why you are using a XY chart when Excel's Line chart can do
such clever thing when the x-values are a time series - it can cope with
missing dates and even non-sequential dates.
Give it a try - quot;those who like it, like it a lotquot; (that's a Canadian beer
ad slogan!)

BTW: With Line charts I generally ensure the x-values have no header in the
top cell when the values are numerical
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

quot;Michael Rylequot; gt; wrote in message
...
gt;I have a spread sheet with the following three series:
gt;
gt; Series 1 (column 1) is A:2 through A:25, formatted date, values Jan 2005
gt; through Dec 2005
gt;
gt; Series 2 (column 2) is B:2 through B:25, fomatted number, values integers
gt;
gt; Series 3 (column 3) is C:2 through C:25, formatted number, values integers
gt;
gt; I select these three columns and then invoke the chart wizard to make a
gt; line
gt; chart based on them.
gt;
gt; Series 2 (column 2) is assigned to one line of the chart. Series 3
gt; (column
gt; 3) is assigned to another line. Series 1 (column 1), the list of dates,
gt; is
gt; assigned to the quot;Category (X) axis labelquot;.
gt;
gt; When Excel creates the chart, the list of dates beneath the X axis is
gt; extended from Dec 2005 all the way out August 2006, even though the list
gt; ends
gt; with Dec 2005 and there are no values for these dates.
gt;
gt; Anybody know what's going on? Thanks.
gt;
Thanks for the suggestion. Manually reformatting the X axis does the job,
though you shouldn't have to. There is obviously a bug in the wizard
(surprise, surprise).

quot;Bernard Liengmequot; wrote:

gt; Hi Michael:
gt; The x-axis scale range is something of a mystery; I nearly always have to
gt; use Format | Axis, open Scale tab and change Min and Max values.
gt; But I wonder why you are using a XY chart when Excel's Line chart can do
gt; such clever thing when the x-values are a time series - it can cope with
gt; missing dates and even non-sequential dates.
gt; Give it a try - quot;those who like it, like it a lotquot; (that's a Canadian beer
gt; ad slogan!)
gt;
gt; BTW: With Line charts I generally ensure the x-values have no header in the
gt; top cell when the values are numerical
gt; best wishes
gt; --
gt; Bernard V Liengme
gt; www.stfx.ca/people/bliengme
gt; remove caps from email
gt;
gt; quot;Michael Rylequot; gt; wrote in message
gt; ...
gt; gt;I have a spread sheet with the following three series:
gt; gt;
gt; gt; Series 1 (column 1) is A:2 through A:25, formatted date, values Jan 2005
gt; gt; through Dec 2005
gt; gt;
gt; gt; Series 2 (column 2) is B:2 through B:25, fomatted number, values integers
gt; gt;
gt; gt; Series 3 (column 3) is C:2 through C:25, formatted number, values integers
gt; gt;
gt; gt; I select these three columns and then invoke the chart wizard to make a
gt; gt; line
gt; gt; chart based on them.
gt; gt;
gt; gt; Series 2 (column 2) is assigned to one line of the chart. Series 3
gt; gt; (column
gt; gt; 3) is assigned to another line. Series 1 (column 1), the list of dates,
gt; gt; is
gt; gt; assigned to the quot;Category (X) axis labelquot;.
gt; gt;
gt; gt; When Excel creates the chart, the list of dates beneath the X axis is
gt; gt; extended from Dec 2005 all the way out August 2006, even though the list
gt; gt; ends
gt; gt; with Dec 2005 and there are no values for these dates.
gt; gt;
gt; gt; Anybody know what's going on? Thanks.
gt; gt;
gt;
gt;
gt;