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

    Display multiple dimensions as columns in graph


      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


      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.