Put the dates in one column and the times in the next column.

If you've got data which is date & time together in Excel's format you may
need to split them
=INT(A1) will give date and =MOD(A1,1) will give time.

Select the two columns, and Insert/ Chart.

If you are getting a wrong result, you may need to tell us what result you
are getting.
--
David Biddulph

"ingalla" wrote in message
...
Can anyone tell me how to create an xy scatter graph, so I can have the
date
on the x axis the time on the y axis (hourly between 0600 and 2200) and
the
different data displayed. I can not get it to work.

The data is displayed, but the axis information is wrong, date and time.

below is the data i have, but will contain data for the whole week.

Thanks

Andy

Date Trailer Refused Trailer Requested Trailer Delivered
07/11/2006
07/11/2006
07/11/2006
07/11/2006 6:00:00 7:30:00
07/11/2006 8:30:00
07/11/2006 10:00:00
07/11/2006 10:10:00
07/11/2006 12:30:00
08/11/2006 7:45:00 9:00:00