Radar chart - change axis from numbers to text

[alirulez]

Hi Everyone

I have a simple radar chart which I've attached below. The challenge is that I'd like to replace 1,2,3,4,5 with A*, A, B, C, D.

Any ideas will be gratefully appreciated.

	What I think	What He Thinks
Item 1	3	4
Item 2	4	5
Item 3	5	2
Item 4	3	2
Item 5	4	5

<tbody>
</tbody>

Malformed image removed by Moderator.

 

[alirulez]

Oops... sorry, I've tried to remove the gibberish but Can't for some reason.

Also cant attach the image sorry. I hope you get the idea though from the data table.

 

[Andrew Poulsom]

You could try this Add-In:

The XY Chart Labeler Add-in

 

[alirulez]

Thanks Andrew - I can't really use an add-in because Im trying to design a template to be used by many staff and I can just see it going wrong if additional clicks are needed to get this working for them.

As an alternative, I was thinking of using a custom cell format to help. Im trying the below but I get an error saying 'Excel cannot use the number format you typed'

[=1]"D";[=2]"C";[=3]"B";[=4]"A";[=5]"A*"

Thanks in advance.
Regards

 

[Andrew Poulsom]

You won't be able to use a number format because there are too many conditions.