Sorry to post such a boring Question but I am in need of some help with Excel.

And sorry in advanace for not explaining very well!

This is a file I have been working on for a long time and it is huge.

Basically I have 4 Series I want to show in a spider Graph. Within these 4 series was a scale of 0 - 3. So having a spider graph was no problem.

NOW i have to change all the values so the scale goes from A - E (A=5, B=4 etc..) in each of the 4 series.

All my graphs are already in place form when the scale was 0 - 3 (I have about 60 graphs linked to this file)

I dont want to go and create each graph again but I will if its needed because its quite important.

In other words... How the hell do I make a spider graph from letters??

Need some help pretty please

__________________
To Alcohol! Because no good story started with somebody eating a salad!

Can't you just stick with numbers and add appropriate little text boxes to cover the number labels? OK a lot of fiddly work for 60 graphs...

Do you mean a radar chart ?

I'm having difficulty visualizing what you wish to do.

No, theres about 3000 cells with numbers and they all have to be converted to letters. Numbers cant be left in the cells.... Which is the killer!


Yes your right a Radar Chart.

I know nothing about Cars but anyways in the picture I made a mini chart. .. Now instead of the numbers 1 - 5 I have the letters A - E but I still need the graphs to look the same...

Attached Thumbnails