XY graph to show date and time

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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.
 
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.
Click to expand...

Andy, the most important bit is to take the word "Date" out of the cell
that it's currently in. It's an annoying feature of Excel that it tries
to guess which is the x-axis and series labels by looking to see what
cells in the upper left are empty, but Microsoft never tell the user
that, they just assume you're telepathic.
Date Trailer Refused Trailer Requested Trailer Delivered
Click to expand...

Do that and you should be 90% of the way to your goal.
 
Back
Top