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.
On Thu, Nov 19, 2015 at 3:39 PM Nicky Hobbs <[email protected]> wrote: > 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? > > -- > 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 [email protected]. > To post to this group, send email to > [email protected]. > 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 > <https://groups.google.com/d/msgid/google-visualization-api/7282aa6c-5221-419f-8feb-9fc92d420915%40googlegroups.com?utm_medium=email&utm_source=footer> > . > For more options, visit https://groups.google.com/d/optout. > -- *[image: unnamed.gif] * *Sergey Grabkovsky* | SWE | [email protected] -- 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 [email protected]. To post to this group, send email to [email protected]. 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/CAEwwup5%2BERv8JpSnCAh2sncjkLpTKs25qYKqYDTukquVe1H2rQ%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
