4 Replies Latest reply on Oct 11, 2013 9:24 AM by Alex Kerin

    Multiple Survey Question Responses in Stacked Bars

    April Hoy

      I have a spreadsheet full of survey results.  Each row represents a single respondent's answers and each column is a likert-scaled question. 

       

      I'd like to represent the answers to several questions with a series of stacked bar charts.  Each bar would be a question, color in the bar would be a response category, and the height would represent the number of respondents who gave that answer.  I've figured out how to do one bar at a time, but can't get it to work with multiple bars (each representing one question) in a single graph.

       

      I'd also like to filter the responses by department (one of the questions) but I don't think this part will be hard once I figure out the rest.

       

      I've attached a spreadsheet analagous to the one I'm working with.

       

      Thanks,

      April

       

      Message was edited by: April Hoy to fix the example spreadsheet.