XY graph to show date and time
 

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

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

XY graph to show date and time
 

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

XY graph to show date and time
 

On Tue, 7 Nov 2006, in microsoft.public.excel.charting,
ingalla said:
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.

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

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

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.