Make a LINE Graph from numbers and letters

[rachrob7981]

I am trying to create a line graph using letters and number and I do not want to give the data values and creat a graph from the values. Does anyone know how to do this.

For example, I want to be able to plot the following as a line chart.
Thank you

Key Stage 2	End of Y7	End of Y8	End of Y9
P7	P7	P8	1c
P8	P8	1c	1b
1c	1a	2b	3c
1b	2c	2a	3b
1a	2b	3c	3a
2c	2a	3b	4c
2b	3c	3a	4b
2a	3b	4c	4a
3c	3a	4b	5c
3b	4c	4a	5b
3a	4b	5c	5a
4c	5c	6c	6b
4b	5b	6b	6a
4a	5a	6a	7c
5c	6c	7c	7a
5b	6b	7b	8c
5a	6a	7a	8b

<tbody>
</tbody>

 

[rachrob7981]

Also on
Make a LINE Graph from numbers and letters