Words on Scaled Chart Axis
Posted by Andrew Watson on January 07, 2002 11:11 PM
I have just been asked to chart a satisfaction survey in Excel.
The items surveyed were:
Each of these could be rated as:
1 Very Dissatisfied
5 Very Satisfied
I have calculated the average rating for each item for all projects. Some items could have non-integer values.
I want a bar chart with the items on the horizontal axis and the ratings on the left hand axis. But instead of showing 1, 2, 3, 4, 5 I want to show the rating descriptions.
Does anyone have any suggestions how I might replace the numbers with words?
I thought I might have a look at custom number formats but at this stage I don't know how to do it.
I know I don't want to just write the labels manually. I want the system to calculate the correct position.