What's the best chart style for graphing questionnaire response

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
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
 
I absolutely agree

Tushar Mehta said:
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
Click to expand...
 
Back
Top