Solution to Charting Problem

[cosmica67]

Hi, All.

I am trying to come up with a solution to a problem I have with some data I need to chart.

I have attached the test data.

What I need to do is produce a line graph that uses and compares the data over a 6 year period for each subject, ideally one which I can somehow use a searching facility or lookup table if possible.

Would there be an easier way that just searching manually for the data, especially since there is a lot more data than is shown in the test data file?


The example data below shows what two data samples would look like for subject 1:


2011-2012 1 0.96
2012-2013 2 1.58
2013-2014 3 1.96
2014-2015 4 2.04
2015-2016 5 1.92
2016-2017 6 1.61


2012-2013 1 1.09
2013-2014 2 1.90
2014-2015 3 2.41
2015-2016 4 2.39
2016-2017 5 2.11
2017-2018 6 1.80


Thank you for looking,

Regards,

Test Data.xlsx
	A	B	C	D	E	F
1	Year	Class	Subject 1	Subject 2	Subject 3	Subject 4
2	2011-2012	1	0.96	0.57	1.05	1.12
3	2012-2013	1	1.09	0.90	1.32	1.39
4	2012-2013	2	1.58	1.26	1.69	1.34
5	2013-2014	1	1.24	1.05	1.30	1.49
6	2013-2014	2	1.90	1.79	1.76	1.52
7	2013-2014	3	1.96	1.73	2.03	1.49
8	2014-2015	1	1.15	0.96	1.14	1.56
9	2014-2015	2	2.27	2.02	2.20	1.59
10	2014-2015	3	2.41	2.34	2.22	1.56
11	2014-2015	4	2.04	1.88	1.94	1.46
12	2015-2016	1	0.90	0.75	1.09	1.41
13	2015-2016	2	2.17	2.01	2.26	1.66
14	2015-2016	3	2.65	2.69	2.42	1.65
15	2015-2016	4	2.39	2.39	2.23	1.64
16	2015-2016	5	1.92	1.67	2.06	1.63
17	2016-2017	1	0.47	0.28	0.55	1.31
18	2016-2017	2	1.92	1.69	2.07	1.50
19	2016-2017	3	2.93	2.79	2.80	1.92
20	2016-2017	4	2.52	2.23	2.58	1.69
21	2016-2017	5	2.11	1.81	2.09	2.02
22	2016-2017	6	1.61	1.27	1.63	1.56
23	2017-2018	1	1.47	1.13	1.63	1.29
24	2017-2018	2	1.66	1.29	1.71	1.35
25	2017-2018	3	2.39	2.27	2.49	1.78
26	2017-2018	4	2.45	2.08	2.47	2.04
27	2017-2018	5	2.37	1.56	2.48	1.99
28	2017-2018	6	1.80	1.31	1.80	2.07
29	2018-2019	1	0.84	0.76	1.06	1.11
30	2018-2019	2	2.15	1.97	2.09	1.47
31	2018-2019	3	2.24	1.97	2.23	1.73
32	2018-2019	4	2.49	2.17	2.74	1.98
33	2018-2019	5	2.39	1.81	2.65	2.30
34	2018-2019	6	2.08	1.36	2.22	2.37
35	2019-2020	1	1.02	0.92	0.83	1.07
36	2019-2020	2	2.57	2.94	1.96	1.40
37	2019-2020	3	2.51	2.47	2.26	1.74
38	2019-2020	4	2.47	2.31	2.43	1.99
39	2019-2020	5	2.32	1.63	2.55	2.13
40	2019-2020	6	2.08	1.36	2.29	2.65
41	2020-2021	1	1.11	0.98	1.12	1.37
42	2020-2021	2	1.91	1.56	1.71	1.64
43	2020-2021	3	2.51	2.40	2.31	1.76
44	2020-2021	4	2.26	1.95	2.10	1.93
45	2020-2021	5	2.24	1.58	2.32	2.13
46	2020-2021	6	2.23	1.57	2.11	2.49
Test Data