# Excel Graphs - displaying questionnaire results on one

#### NJS1982

##### Board Regular
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!

### Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},\$Z\$1:\$Z\$99,\$Y\$1:\$Y\$99),2,False) to lookup Y values to left of Z values.
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.

Replies
0
Views
124
Replies
0
Views
631
Replies
0
Views
170
Replies
0
Views
328
Replies
4
Views
467

1,203,472
Messages
6,055,610
Members
444,803
Latest member
retrorocket129

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back