2 Replies Latest reply on Oct 20, 2016 3:23 PM by erik.bernheim

    Display multiple dimensions as columns in graph

    erik.bernheim

      Hi, this is my first time using these forums, so I apologize in advance for any mistakes.

       

      I have an excel file from a survey program that is similar to the one below

       

      TimestampQuestion 1Question 2Question 4Question 5
      11/05/2016OrangeAppleGrape
      11/09/2016Banana
      11/10/2016AppleGrape

       

      This data is the result of a checkboxes in a survey. The value in each column will either be the value of the answer that was checked or null. I don't need to graph users choosing an exact sequence of checkboxes. I'm trying to create a histogram  where the Y axis is the number of times a particular box was checked, and the X axis will be the choices.

       

       

      For the data above the chart would look like this.

      Screen Shot 2016-10-20 at 5.50.32 PM.png

       

      I'm also trying to keep each entry associated with it's timestamp, because I will be also plotting this over time (3+ years of data)

       

      If anything is unclear please let me know, any help is appreciated.