software

I am a schoolteacher and grade pupils on levels which have lettered bands
within, such as 6a, 6b, 6c etc.

Is there a way to plot these on an excel chart without meassigning them
values, such as 68, 65, 62 etc?????

Please help...

Maybe it is a programming issue so I post there too.

Thanks.

You do need to assign numerical values, because Excel plots text as zero.
You could use a lookup table for this. To make the axis display text instead
of numbers, use a dummy series as your new axis:

peltiertech.com/Excel/Charts/ArbitraryAxis.html
peltiertech.com/Excel/Charts/Y_CategoryAxis.html

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

quot;PG Orielquot; gt; wrote in message
...
gt;I am a schoolteacher and grade pupils on levels which have lettered bands
gt; within, such as 6a, 6b, 6c etc.
gt;
gt; Is there a way to plot these on an excel chart without meassigning them
gt; values, such as 68, 65, 62 etc?????
gt;
gt; Please help...
gt;
gt; Maybe it is a programming issue so I post there too.
gt;
gt; Thanks.