Thread: Chart Problem
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Michael Ryle
 
Posts: n/a
Default Chart Problem

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 "Category (X) axis label".

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.