Create a helper column that includes both the date and time and use that as
your X series.
"cdoughty" wrote:
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