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
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