PC Review


Reply
Thread Tools Rate Thread

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

 
 
=?Utf-8?B?bWFyZWFoXzAzMTE=?=
Guest
Posts: n/a
 
      16th Sep 2006
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!!!
 
Reply With Quote
 
 
 
 
=?Utf-8?B?RmxvTU0y?=
Guest
Posts: n/a
 
      17th Sep 2006
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" wrote:

> 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!!!

 
Reply With Quote
 
Tushar Mehta
Guest
Posts: n/a
 
      17th Sep 2006
In article <05CBBEC7-C78B-42FE-A250-(E-Mail Removed)>, mareah_0311
@discussions.microsoft.com says...
> 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!!!
>

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
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
SENIOR DEVELOPMENT ENGINEER - C/C++ and Java - Electronics/Crytography/VideoStreaming ideally - Based in Auckland - Highly Ranked destination of Choice(Lonely Planet Survey). Rosemary Jackson Windows XP Video 0 1st Dec 2010 09:49 PM
Bar Graph not allowing choice of X axis tshad Microsoft Excel Charting 1 28th Nov 2007 12:34 PM
multiple-choice survey stephen Microsoft Frontpage 8 11th Mar 2005 10:48 AM
create graph for survey results =?Utf-8?B?R0pNY0c=?= Microsoft Excel Charting 1 18th Oct 2004 12:28 AM
force graph to axis of choice bbxrider Microsoft Excel Charting 6 12th Feb 2004 10:51 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:04 PM.