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.