Excel 2003 - Chart a time value for each day

[CongoGrey]

Hi, I hope one of you can help me today.
I have a program which finds the last treatment time for each day.
I have been asked to graph it in Excel with the dates as an x axis, the time on the y axis and of course, the values at the intersection of the date and time.

I have been at it all afternoon and cannot seem to get close. Either the time displays on the y-axis and the date on the x-axis and I get no values, or the values display and I cannot get the time and date values to display as axis labels. When the values display they are a datetime field. When the time displays on the y-axis it is a 12 am - 12 pm (this is OK). However, the dates on the x-axis must be the dates in the dataset.

I am no longer thinking clearly. I'm not even sure anymore which chart type to use. Any assistance that you can offer will be gratefully received and faithfully played with.
Thank you in advance.

 

[CDICKENS]

Do you have the times in a separate column?
Chuck

 

[CongoGrey]

Good Morning Chuck, Yes.
My Excel 2003 sheet contains datetime, date, and time columns (3 separate columns). I have made sure that the date column really is an Excel date datatype.

I am having trouble thinking about how to express the datapoints (the datetime column?).