1) You have column headers: Date, Rise, Set. Delete the first one )Date) and
make the chart. Excel will now treat the first column as the x-values rather
than the first y-value series.

2) Replace the blank by =NA() which displays as #N/A. The chart engine will
ignore this point

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"cmccloskey56" wrote in message
...
I want to plot date against time. I have dates, the moonrise and moonset
times. I would like the date on the horizontal axis and a time scale on
the
vertical axis, plotting the time of the moonrise and moonset as two
different
series.
The data looks like this:
Date Rise Set
10/01/07 21:03 12:05
10/02/07 22:06 13:09
10/03/07 23:14 14:01
10/04/07 14:43
10/05/07 0:23 15:16
10/06/07 1:31 15:43
...
(sometimes rise/set are blank because the moon rose on the previous day;
there was no moonrise on a specific date)

I understand that the preferred format is an XY chart (lines)?
When I do it this way I get THREE series, of rise, set AND date.
Here are my questions:
1. How do I get the date back on the horizontal axis?
2. How do I get Time displayes on the vertical axis in more intervals,
preferably by hour?

I am using Excel 2007.

Thanks for your help!

Colleen