How to Analyze the Trend of Data In Google Spreadsheet and Excel

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?

user190109

Posted 2013-01-15T12:57:29.983

Reputation: 1

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

No answers