Cindy

This is going to sound a bit crazy, but why don't you combine the date
and time into one column and plot that against the temperature? You can
enter time and date as one whole thing by entering the details as a full
date/time -as an example
15:30 25/12/05. Excel recognises time by the colon seperating hours
from minutes and date by the slashes. I don't know if you are using US
date format which would have the same day as 12/25/05, but it needs to
be consistant with the way you have the computer set up.
Enter the temperatures as you like against this column and plot them
using the XY Scatter option in Charts


--
Jon Quixley
------------------------------------------------------------------------
Jon Quixley's Profile: http://www.excelforum.com/member.php...o&userid=25803
View this thread: http://www.excelforum.com/showthread...hreadid=398141