alphanumeric data chart
Hi all.
I'm trying to put together a spread sheet that records the progress of pupils through the year in 3 subjects over 3 terms.
I'd like to create a line chart for each pupil showing a line for each subject, Y axis as level and X axis as term (1,2 & 3).
The problem i'm having is that the levels are alphanumeric: low to high in the following order:
1c - 1b - 1a - 2c - 2b - 2a - 3c - 3b - 3a.
Any help with this will be gratefully recieved.
Thanks.
|