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

Don't worry, I'm here to help! Setting up a graph from a multiple choice survey in Excel is actually quite simple. Here are the steps you can follow:

1. Open a new Excel spreadsheet and enter the survey data. Each row should represent a respondent, and each column should represent a question. Enter the responses as numerical values (e.g. 1 for option A, 2 for option B, etc.).
2. Once you have entered all the data, select the entire range of cells containing the data.
3. Click on the "Insert" tab in the Excel ribbon, and then select the type of chart you want to create. For a multiple choice survey, a column chart or a bar chart would be appropriate.
4. Excel will automatically create a chart based on the selected data. You can customize the chart by adding titles, labels, and formatting options.
5. Once you have customized the chart to your liking, you can save it as an image or copy and paste it into your thesis document.

That's it! With these steps, you should be able to create a chart or graph from your multiple choice survey data in Excel. Let me know if you have any questions or need further assistance.

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

In article , 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