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,
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 |