up vote 2 down vote favorite
1
share [g+] share [fb]

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?

Thanks

---EDIT-----

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:

[=-15]"AA";[=-10]"A";General

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?

Thanks

link|improve this question
You are on Excel 2003 or Excel 2007? – Graviton Oct 7 '09 at 1:03
I am using Excel 2007 – Irfy Oct 7 '09 at 16:48
feedback

migrated from stackoverflow.com Oct 7 '09 at 0:10

This question came from our site for professional and enthusiast programmers.

3 Answers

up vote 1 down vote accepted

It can be done with a bit of trickery, but if it's a simple chart, it's almost definitely easier to just manually draw some new labels using text boxes with opaque backgrounds over the existing labels.

But...

Hide the existing Y-axis ticks and labels, then plot a new X-Y series of points like this:

x y

0 1

0 2

0 3

0 4

. .

By changing the format of the point markers to something suitable, like horizontal lines,you'll get a new set of tickmarks straight up the y-axis.

Unfortunately this is where it gets a little more fiddly. You now need to plot a data label for each point to form your new y-axis tick labels. As far as I know not even the latest version of Excel can do this automatically, but you'll find various macros to do this for you (Google: Excel X-Y scatter point labeller).

You'll then be able to add an extra column:

x y label

0 1 f 

0 2 e

0 3 d

0 4 c

. . .

Run the macro and each pseudo-tickmark will have a label next to it. But you'll need to play with label alignment settings to get them in the right place.

link|improve this answer
Thanks elliot, this is certainly an option that I may look at, however I've been reading about using the format string to try and achieve this: please see the edits to my original post. – Irfy Oct 7 '09 at 16:49
That would be rather easier if it worked! – e100 Oct 7 '09 at 17:11
Strange, which version of excel are you using elliot? – Irfy Oct 8 '09 at 14:59
2000/2003.. but all I meant by previous comment was that if you get it your axis custom number format method to work for more than two values, it would be far easier than using my suggestion :-) – e100 Oct 8 '09 at 17:04
ah! Unfortunately, it's still not quite there. I still have a week before I'm going to have to look at your solution. But for now I'm gonna mark this as the answer. Thanks for you help! – Irfy Oct 15 '09 at 13:23
feedback
up vote 0 down vote

you may try this: http://peltiertech.com/WordPress/custom-axis-y-1-2-4-8-16/

Look for where he mentions the chart labeler found here: appspro.com/Utilities/ChartLabeler.htm

link|improve this answer
feedback
up vote -2 down vote

Not sure if I got this right as I don't really understand what you are asking, but if you are talking about the names across the axis you can use the following:

enter image description here

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.