Can the Times Medication Administered and Times Specific Event Occurs be on
the same Worsheet? It makes it easier if you answer yes!

"val" wrote:

I am trying to chart two sets of data on one chart. The data sets will come
from sheets within the same spreadsheet.

Both sets use dates, but they might be different dates, so I'd like to have
the x axis show consecutive dates (e.g 1-1-10 through 1-31-10)

The y axis in both cases will be time of day. I want to display time by
hourly increments for 24 hours on this axis.

I want the chart to show times medication is administered (from sheet 1)
and times a specific event occurs (from sheet 2)

I have been trying for hours and getting nowhere. I generally chart using
bars, but did not think this would be so different.

Help, please.

Val