View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier
 
Posts: n/a
Default Graphing using text??

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:

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

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

"PG Oriel" wrote in message
...
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.