Combo Chart - linking data to different data points

[MrAWilks]

I have attempted to attach the mini sheet below with a Data Input table in which I have created.

All of the cells in the Standard columns have a drop down list connected to them including the following: Year 1, Year 2, Year 3 etc.

The cells in the ticks column is a manual entry.

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1					Year 1
2					Autumn 1		Autumn 2		Spring 1		Spring 2		Summer 1		Summer 2
3			Name:		Standard	Ticks	Standard	Ticks	Standard	Ticks	Standard	Ticks	Standard	Ticks	Standard	Ticks
4			Child A		Year 1	8.00	Year 1	13.00	Year 1	15.00	Year 1	19.00	Year 2	5.00	Year 2	7.00
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39					Year 1
40					Year 2
41					Year 3
42					Year 4
43					Year 5
44					Year 6
Data Input

Cells with Data Validation
Cell	Allow	Criteria
M4:M34	List	=$E$39:$E$44
E4:E33	List	=$E$39:$E$44
G4:G34	List	=$E$39:$E$44
I4:I34	List	=$E$39:$E$44
K4:K34	List	=$E$39:$E$44
O4:O34	List	=$E$39:$E$44

I would like this data to link to another sheet, the one that is hopefully attached below.

Book1
	A	B	C	D	E	F
1			Not yet at Standard	Developing	Secure	Advanced
2	Year 1 Standard	Autumn 1	5	4	8	3
3		Autumn 2	5	4	8	3
4		Spring 1	5	4	8	3
5		Spring 2	5	4	8	3
6		Summer 1	5	4	8	3
7		Summer 2	5	4	8	3
8
9	Year 2 Standard	Autumn 1	5	4	8	3
10		Autumn 2	5	4	8	3
11		Spring 1	5	4	8	3
12		Spring 2	5	4	8	3
13		Summer 1	5	4	8	3
14		Summer 2	5	4	8	3
15
16	Year 3 Standard	Autumn 1	5	4	8	3
17		Autumn 2	5	4	8	3
18		Spring 1	5	4	8	3
19		Spring 2	5	4	8	3
20		Summer 1	5	4	8	3
21		Summer 2	5	4	8	3
22
23	Year 4 Standard	Autumn 1	5	4	8	3
24		Autumn 2	5	4	8	3
25		Spring 1	5	4	8	3
26		Spring 2	5	4	8	3
27		Summer 1	5	4	8	3
28		Summer 2	5	4	8	3
29
30	Year 5 Standard	Autumn 1	5	4	8	3
31		Autumn 2	5	4	8	3
32		Spring 1	5	4	8	3
33		Spring 2	5	4	8	3
34		Summer 1	5	4	8	3
35		Summer 2	5	4	8	3
36
37	Year 6 Standard	Autumn 1	5	4	8	3
38		Autumn 2	5	4	8	3
39		Spring 1	5	4	8	3
40		Spring 2	5	4	8	3
41		Summer 1	5	4	8	3
42		Summer 2	5	4	8	3
Child A

The issue is where in Summer 1, Child A has moved up from the Year 1 Standard to the Year 2 Standard, I would like that to be shown as such in the Combo Chart which I have attached.

I'll be honest I do not have any ideas how to do this so any help would be greatly appreciated!