Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I would like to graph my survey results with the numerical values of the responses listed on the vertical axis and the questions listed on the horizontal axis.

For example, I imagine the questions noted on the horizontal axis as Q1, Q2, Q3, Q4, etc. On the vertical axis, I imagine the actual numerical values (responses) noted by a bar graph.

The possible answers use a 5 point Likert scale (very satisfied to very dissatisfied) that have a numerical 1-5 attached to them, "1" equals very dissatisfied.

How can I graph this?

share|improve this question
    
Do you want to create the chart for a single survey response (i.e., from one respondent)? Or do you want some sort of summary statistic charted for each question (i.e., from many respondents)? – Excellll Aug 23 '13 at 20:46

Questions in column A, actual responses for each question in column B. Select the entire range, then choose a bar graph. You can edit the graph by right-clicking on it.

share|improve this answer

If I understand what you're asking for, you want a graph that shows, for example:

Question "I like ice cream": 40% strongly agree, 30% agree, 10% neutral, 15% disagree, 5% strongly disagree

Question "I like popcorn": [array of Likert scale proportions similar to the above]

Set up a table in Excel with the questions in column A, % strongly agree in column B, % agree in column C, ... % strongly disagree in column F. You may need to do a fair bit of copy/paste/transposing your data to get this table together. You can also use the raw numbers of respondents instead of percentages.

Then select the whole table, and insert a "stacked column" graph.

If your question stubs are long (more than a few words each), you might be better off with a "stacked bar" graph, running the question stubs vertically and the data bars horizontally.

Hope that helps.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.