Senior Experience for graduation

[mkyb14]

ok, I'm in a little deep on the excel. Possibly we set our data collection up wrong when using google forms.

Attached is the results of a blind survey we conducted. Google forms shows the results via their graphs etc, but we as the group need to do more in-depth analysis of the results. We have for example a set of hobbies that people could have chosen, autos, computers, knitting ... what ever they liked.

I am a little stumped on how google graphed the data from one cell that has multiple items that are separated by comma's .

Any help would be appreciated. I don't know if I need to separate out the cells with multiple choices inputted etc.

Below contains the excel 2007 sheet, as well as, the google charts saved as a webpage since I can't give access to everyone.
http://www.wonderliver.com/dl/GoogleData.zip

Thank you,

Mike

 

[mkyb14]

sorry, error with htaccess... here is a link that will work

http://www.wonderliver.com/downloads/GoogleData.zip

 

[mkyb14]

no one has a way to explain how to graph or break down a cell that has multiple entries?

[house,boat,car,plane] - representing a single cell