View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default XY graph to show date and time

I made a Line chart of this data that seems OK
Had to format the y-axis as Time
Try this and then tell us more specifically what goes wrong
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"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