Suppose your data start with row 2 column A with date in column A, time
in B and temp. in C.

Combine date and time into another column with the formula. Say, in D2
enter =A2+B2. Duplicate C into E by entering in E2 =C2. Copy D2:E2 as
far down as you have data. Plot D:E in a XY Scatter chart.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...

I have three columns (Date, Time, and Temperature) that I am trying to
graph as a scatter chart. I would like Date and Time together on the
x-axis and I would like Temperature on the y-axis. I can't get the
date and time combined on the x-axis. There are multiple measurements
on the same day and the measurements are not spaced evenly. I would
like the scale to be with a consistent unit (i.e. certain number of
hours between points). Any suggestions?

Thanks,
Cindy


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