Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have the following data:

Time    v
0   5.4
5   4.5
10  5.3
15  6
20  5.1
25  7.4
30  6.7
40  6.1
50  6.9
60  5.9
70  6.1
80  6.2

Time    v
0   4.7
5   4.8
10  5.5
15  6.1
20  6.8
25  7.5
30  7.9
40  8.2
45  9.2
50  9.9
55  8.6
60  8.4
65  7.1
70  7
75  6.3
85  5.2

Time    v 
0   5.1
5   5.4
10  5.7
15  6.7
20  6.8
25  7.6
30  7.4
35  6.3
40  6.6
45  6.3
50  6.9
55  6.8
60  6.2
65  6.2
75  5.7
85  6.1
95  5.6
105 5.4

Time    v 
0   4.5
4   5
8   5.4
12  5.6
16  6.2
20  5.9
24  6.3
28  6
32  7.3
36  6.4
40  5.7
44  5.4
48  5.4

And each section represents a separate line that I want to be plotted on a graph. As you can see, the time values are different for each recordings and I am not able to figure out a way to embed all these different sections into their individual lines in a excel line graph.

Any help?

(I am using both Google Docs and Microsoft Excel spreadsheet)

share|improve this question
    
Your question says line graph though I agree with Simon that scatter seems more appropriate - are you flexible on which? –  pnuts Jun 14 '13 at 9:34

2 Answers 2

Another alternative is to use an Excel Scatter plot, which lets you choose different sets of time (X) values for each data set plotted:

enter image description here

share|improve this answer
    
+1 Definitely should be scatter (I was trying to answer a different question!). –  pnuts Jun 12 '13 at 10:03

I'd suggest rearranging your data as on the left in the image below (if a chart as on the right is something like your requirement!):

SU606489 example

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.