Creating a chart from form data with multiple entries per cell

[Nicky Hobbs]

Hello,

I have created a Google form with checkbox entries.  In my corresponding sheet that collects the data, this information is contained in one cell per question.  Here is an example:

Question:  What foods to you enjoy?

Responses that are checked: Fries, Seafood, Chicken

In my sheet these responses would all be in the same cell and separated by commas just as above.  I need to create a bar chart so that it separates the responses.  This means that I would have a bar for "Fries" and a bar for "Seafood" and a bar for "Chicken"  Currently, I don't see how to do this.  Is it possible?

[Sergey Grabkovsky]

Hi Nicky,

We don't have any built-in functions to do this, but you should be able to write some pretty simple JavaScript that iterates over the table and generates a new normalized table. Or you can do this in Sheets with some formulas, and then just construct a histogram from your data.

--
You received this message because you are subscribed to the Google Groups "Google Visualization API" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-visualizati...@googlegroups.com.
To post to this group, send email to google-visua...@googlegroups.com.
Visit this group at http://groups.google.com/group/google-visualization-api.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/7282aa6c-5221-419f-8feb-9fc92d420915%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

 

Sergey Grabkovsky | SWE  | gra...@google.com