Non Numeric Values

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Harry Hornet - 03 Nov 2006 13:19 GMT

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?

Reply to this Message

Jon Peltier - 03 Nov 2006 18:08 GMT

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______

>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
[quoted text clipped - 4 lines]
>
> Is there any easy way of doing this?

Reply to this Message