View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default How do I change the scale on the y axis to letters?

You can hide the default axis labels and add a series along the Y axis that
has the desired text as data point labels.

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

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


"Standard." wrote in message
...
I wish to change the Y axis scale on an Excel line graph from numbers to
letters. Any ideas?

Thanks