Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

1 Answer 1

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

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.