Plotting Timeseries Chart From Table

[andybason]

Hello

I have a table that contains a timeseries in the first column, a test number in the second and a result value in the third. Extract below.

Is there a simple way of plotting the results for each test as a line chart against the timeseries?

So timeseries is on the x axis then a line for each test number. At the moment I just filter for each test then copy/paste the result data into different columns and then plot the chart from there.

This seems unnecessarily time consuming so I am hoping there's a better way.

Thank you

Values_1.184688001.csv
	A	B	C
1	Time	Test	Value
2	14:38:23.863	1	2.74
3	14:38:23.863	2	3.65
4	14:38:23.863	3	2.26
5	14:38:23.863	4	29
6	14:38:23.863	5	50
7	14:38:23.863	6	80
8	14:38:23.863	7	70
9	14:38:23.863	8	120
10	14:38:23.863	9	180
11	14:38:23.881	1	2.74
12	14:38:23.881	2	3.65
13	14:38:23.881	3	2.26
14	14:38:23.881	4	29
15	14:38:23.881	5	50
16	14:38:23.881	6	80
17	14:38:23.881	7	70
18	14:38:23.881	8	120
19	14:38:23.881	9	180
20	14:38:23.910	1	2.74
21	14:38:23.910	2	3.65
22	14:38:23.910	3	2.26
23	14:38:23.910	4	29
24	14:38:23.910	5	50
25	14:38:23.910	6	80
26	14:38:23.910	7	70
27	14:38:23.910	8	120
28	14:38:23.910	9	180
29	14:38:23.940	1	2.74
30	14:38:23.940	2	3.65
31	14:38:23.940	3	2.26
32	14:38:23.940	4	29
33	14:38:23.940	5	50
34	14:38:23.940	6	80
35	14:38:23.940	7	70
36	14:38:23.940	8	120
37	14:38:23.940	9	180
Values_1.184688001

 

[Saba Sabaratnam]

You could build series of pivot tables for each of test and create pivot charts as shown below.

Refresh it every time you add new data.

Kind regards

Saba

 

[andybason]

Thank you Saba