Date and Time on X-axis

[cdoughty]

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

Thanks,
Cind

 

[Jon Quixley]

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

 

[Tushar Mehta]

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

 

[Barb Reinhardt]

Create a helper column that includes both the date and time and use that as
your X series.

 

[Amedee Van Gasse]

In <[email protected]>, 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.

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? ;-)