Combining two columns into one X-axis?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Steen Suder - 10 Apr 2008 20:29 GMT

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.

Signature

Steen Suder

Reply to this Message

Pete_UK - 10 Apr 2008 21:19 GMT

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

>I have a sheet with three columns of numbers, I would like to plot:
>
[quoted text clipped - 18 lines]
> used -
> then I can take it from there.

Reply to this Message