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