0
I am using google spreadsheet to gather survey data: The spreadsheet looks like this
Timestamp Choice Comment
1/15/2013 4:24:29 A Comment goes here
1/15/2013 4:24:32 B
1/15/2013 4:24:37 A
1/15/2013 4:24:40 B
1/15/2013 4:24:44 A
1/15/2013 4:24:48 A
1/15/2013 4:24:53 A
Is there any way to compile the information and create a line graph to display the trend of A and B over time?
I would use a Pivot table. – Pynner – 2013-01-15T22:29:55.697
Take a look at this answer: http://webapps.stackexchange.com/a/36917/29140
– Jacob Jan Tuinstra – 2013-01-17T21:13:20.100