I have a list of students with their grades at the end of each year. The
grades are alphanumeric - 3C, 4B and so on. I need to make a chart for each
student that shows their grades year on year and then with a trend line (?)
to predict their ultimate grade.

Is there any easy way of doing this?