Excel Graphs - displaying questionnaire results on one

[NJS1982]

Does anyone know how I can possibly display all of the results from a satisfaction questionnaire on one clear horizontal line graph?

I have 300 responses, 17 questions, all answering either 'very satisfied', 'satisfied', 'neither satisfied nor dissatisfied', 'dissatisfied', 'very dissatisfied' and 'did not use'.

I want to display on one graph with one result to each of the 17 questions, with the most highly rated at the top and least rated at the bottom? I can do it with all collated responses to each question (i.e. 6 responses per question) but I want to display the overall average so at the top there will be the best results and the bottom will be the worst results (actioning work needed from my organisation).<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
Thanks!

 

[Gerald Higgins]

One way would be to apply a score to each answer, for example
Very dissatisfied - 0
Dissatisfied - 1
Neither Sat nor Dis - 2
Sat - 3
Very Sat - 4

Then calculate the total score for each question, and graph that.

If you just do that, you will have a problem because "did not use" will be treated as 0, the same as "very dissatisfied" which you may not want.
So an enhancement would be to calculate the total score for each question, as above, and then divide that result by the number of responses to that question, not including "did not use" responses.
This will give you an average score for each "useage" response.