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!
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!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
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
ASKER
Okay...thanks! I ended downloading this add in on my home computer and it worked like a charm!
ASKER