View Single Post
  #4   Report Post  
Barb Reinhardt
 
Posts: n/a
Default

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