Non Numeric Values

[Guest]

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?

 

[Jon Peltier]

You will need to convert the alphanumeric grades into numeric values, so
that Excel has nonzero values to chart. In order to show the alphanumeric
grades along the Y axis, use a dummy series as demonstrated here:

http://peltiertech.com/Excel/Charts/ArbitraryAxis.html

- Jon