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 he

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Harry Hornet" wrote in message
...
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?