How do I set up a graph out of multiple choice survey?

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

Guest

I am working on my Senior Thesis and trying to take a 10 question multiple
choice survey that I had people complete and chart/graph the results. I
haven't used Excel in years and I am completely lost!!!
 
Mareah_0311,
This is not as complicated as you think.
Column A Column B Column C
1st Question Asked Responder1 answer Responder 2 Answer
2nd Question asked ditto ditto
and so on and so forth
Then to make the graph, select all data in cell B2 across top to include all
enties, and down.
Example: If questions are in column A (A1 thru A50) A1:A50 and there were
four people responding, there resonses would be in columns B thru F. Their
answer would fill down the columns.
Once the data is highlighted, select the "Chart Wizard", it looks like a
little bar graph. Depending on how you want your data to look depends on your
selection. But you can always change your mind and go back.

Good luck,
 
mareah_0311 said:
I am working on my Senior Thesis and trying to take a 10 question multiple
choice survey that I had people complete and chart/graph the results. I
haven't used Excel in years and I am completely lost!!!
Click to expand...
One possibility:

Organize your data so that the responses from each person taking the test
are in one row. Take the answers and put them one answer per column. So,
if the names/ids of the responders are in column A, the answer to question 1
will be in column B, the response to question 2 in column C, etc.

Now, use XL's PivotTable (and if appropriate PivotChart) capability to
analyze the results. To access the capability, select Data | PivotTable and
PivotChart report...

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Back
Top