ChatterBank1 min ago
Excel Graphs - displaying questionnaire results on one
1 Answers
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', 'dis-satisfied', 'very disattisfied' 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...
I have 300 responses, 17 questions, all answering either 'very satisfied', 'satisfied', 'neither satisfied nor dissatisfied', 'dis-satisfied', 'very disattisfied' 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...
Answers
Best Answer
No best answer has yet been selected by funkylad20. Once a best answer has been selected, it will be shown here.
For more on marking an answer as the "Best Answer", please visit our FAQ.Related Questions
Sorry, we can't find any related questions. Try using the search bar at the top of the page to search for some keywords, or choose a topic and submit your own question.