I'm trying to rename the values that are on my Y Axis on a chart in excel. Currently I have mapped various letters to number equivilants just to get it plotted, but would like now to have the letter equivalents on the Y axis (Think in terms of grading someone on an A-F scale).
Does anyone have an idea on how to do this?
I've discovered something that partially works, if you right click the Y-Axis and select "Format Axis" from this menu. Then choose the "Number" tab, you can enter a "Custom" format string. using something along the lines of:
You can have the ticks substituted with your own values. The new problem is, this solution only seems to work for two values, beyond that it seems to break! Any ideas?