Y Axis labels: How to make them different to figures used to plot.

H

happyhenry

I am plotting a chart of student progress cores. These take the form 4c, 4b,
4a, 5c, 5b, 5a.

To do calculations on them and plot them I have converted them into numbers
in a Lookup: 1, 2 ,3 ,4 ,5 ,6 etc

Works fine. Chart (which plots student performance against target) looks
great. But to make sense to teachers and students the axis must revert to 4c,
4b, 4a - not 1, 2, 3 ,4.

The only solution I have found is to remove Y axis labels and place over
that area a text box with the correct labels. But it keeps shifting on
different views and different printers.

is there any way to get Excel to put 4c where it plots 1, 4b where it plots
2 etc?

(These grades are standard in UK school system, ages 11 to 16.)

Yours

Henry
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top