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