On Fri, 5 Oct 2007, in microsoft.public.excel.charting,
cmccloskey56 said:

How does this help me? I lose the date dimension, and seemingly plot one time
against another.

No, don't delete the Date column, just leave its header row empty. The
Chart Wizard is a bit dim, and is looking for blank spaces in the top
left hand corner of the selected range, in order to be able to figure
which rows and columns you want to be the X axis and which to be the
series titles. For instance, this range:

A B
1 2 2
2 3 4

will produce 1,2 in the x-axis, and name the two data series "A" and
"B". If you give the 1,2 a header, the Wizard gets confused and tries to
plot all three as data series, as you discovered. Once you've
successfully built your chart, you can then give the first column a
label, you don't have to leave it blank.

This also works for more than one row and column. For instance:

X X
A B
2007 1 2 2
2007 2 3 4

Will create a chart where *both* the year column and the numbers 1,2 are
on the x axis, and the series are named XA and XB. This works for many
levels of row and column, depending on how extensive the blank rectangle
in the top left corner is. Again, they only need to be blank while
creating the chart. Afterwards you can fill them with whatever you like.

I want to see two points (lines/series) for each date, with
date as the x-axis and time as the y-axis and two series plotted as different
colors (rise and set).

Somehow I got a chart to show the two time series on the y-axis, I just
wasn't able to get the date on the x-axis as I wished.

The note about #N/A is valuable - I didn't know that one.

It's also okay to just leave the cell blank if it's not causing you any
trouble.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.