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.