Combining two columns into one X-axis?

[Steen Suder]

I have a sheet with three columns of numbers, I would like to plot:

A Date
B Time
C Measured responsetime

Example:
Apr-9-08 15:06 624.0
Apr-9-08 15:05 656.0
Apr-9-08 15:04 623.0
Apr-9-08 15:03 889.0
Apr-9-08 15:02 873.0
Apr-9-08 15:01 702.0
Apr-9-08 15:00 749.0
....



How do I specify a graph, that uses columns A and B "combined" for the
X-axis and column C for the Y-axis or values?

Perhaps just a pointer or hint towards the concept or function to be used -
then I can take it from there.

 

[Pete_UK]

If those are proper Excel dates and times, then use a helper column and add
them together, e.g. insert a new column C and in C1 put this formula:

=A1+B1

Format how you would like it to be, then copy down.

Use the new column C as the source for your X-axis.

Hope this helps.

Pete