In , cdoughty
told us an interesting story. My reply to this story is at the bottom
of this message.


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

For the combination of date&time:
Column A: date
Column B: time
Column C: temperature

Insert a new column before C. Temperature becomes D.
In C you put =A2+B2, and copy this down.
Make a scatter chart with columns C:D.

For the scale:
A scale of 1 in the X-axis is 1 day.
0.5 = 12 hours
0.25 = 6 hours
0.125 = 3 hours
0,04167 = 1 hour

I think you get the picture? ;-)

--
Amedee Van Gasse