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.

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.

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.

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.