How do I conditionally change the y-axis values on chart in Excel?

Dear Experts,

My y-axis scale goes from 0 to 17. How to I change the data points to show letters of the alphabet respectively, i.e. A=1, B=2, C=3, etc. so the data I pull in is numeric but the y-axis displays letters. Can I do some kind of conditional statement? I want the scale to show A to Q.

Thanks!
shogun5Asked:
Who is Participating?
 
Rgonzo1971Connect With a Mentor Commented:
0
 
shogun5Author Commented:
Thanks! But I am working a government computer and cannot download and install any Excel addins. I need to figure this one out with the Existing Excel software.
0
 
Rgonzo1971Commented:
Hi,

Follow the the instructions
http://peltiertech.com/Excel/Charts/Y_CategoryAxis.html

If you cannot use an add-in you have to hide the normal y- axis, give labels to the dummy serie data points, then place the labels left from the data points, and then manually change the text of each label

You could use this macro to add labels

http://support.microsoft.com/kb/213750/en-us

Regards
0
 
shogun5Author Commented:
Okay...thanks! I ended downloading this add in on my home computer and it worked like a charm!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.