Home |
Search |
Today's Posts |
#1
|
|||
|
|||
What's the best chart style for graphing questionnaire response
I have to graph responses gathered from a 7 question survey given at the end
of training courses. Scale of response is 1 thru to 5 with approx 12 attendees on each course within 15 training sessions. I'm using Excel 2003. |
#2
|
|||
|
|||
I would recommend The three D Column Chart with the questions as catagories
and response level as series (Set up 5 series ) Count the number of "1"s for question 1 and enter this value into series 1 at catagory 1 do this for alll of the responses and all of the response levels. "gemini1215" wrote: I have to graph responses gathered from a 7 question survey given at the end of training courses. Scale of response is 1 thru to 5 with approx 12 attendees on each course within 15 training sessions. I'm using Excel 2003. |
#3
|
|||
|
|||
There is no single best chart style. It all depends on what you want
to do and how you want to "slice-and-dice" the results. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... I have to graph responses gathered from a 7 question survey given at the end of training courses. Scale of response is 1 thru to 5 with approx 12 attendees on each course within 15 training sessions. I'm using Excel 2003. |
#4
|
|||
|
|||
I absolutely agree
"Tushar Mehta" wrote: There is no single best chart style. It all depends on what you want to do and how you want to "slice-and-dice" the results. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... I have to graph responses gathered from a 7 question survey given at the end of training courses. Scale of response is 1 thru to 5 with approx 12 attendees on each course within 15 training sessions. I'm using Excel 2003. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Urgent Chart Assistance | Charts and Charting in Excel | |||
Urgent Chart Questions | Excel Discussion (Misc queries) | |||
Urgent Chart Assistance Requested | Excel Discussion (Misc queries) | |||
Scrollbar on Chart Jumps to Left when Chart is Clicked | Charts and Charting in Excel | |||
pivot table multi line chart | Charts and Charting in Excel |