3 Replies Latest reply on Feb 21, 2011 2:31 AM by Steve Wexler

    Visualizing simple Likert scales

    Del Myers

      This is probably a really simple problem, but I haven't been able to get this figured out for the past couple of hours. Hopefully someone could help me.

       

      Basically, I have a survey in which there are a number of questions (q1....qn) that users (u1...un) were asked to answer on a 5 point Likert scale. So, the data would look something like this:

       

       



      user  q1 q2 q3....

      1      2  3  1

      2      4  1  2

      3      3  1  5

      .

      .

      .

       



       

      I want to have a chart that shows the total count for each response (3 "1"s, 800 "2"s, etc...) as the size of a bar in a bar chart, color-coded by which question they answered (q1 blue, q2 red, etc.)... basically a stacked bar chart. Does anyone have any idea how to do this? Thanks.