Hi, There are several ways to perform what you are looking for: 1. If you consume the data from your own HTML, and use the visualization from JavaScript and you know the (maximum) number of elements that each of your cell contains, you can use a DataView<http://code.google.com/apis/visualization/documentation/reference.html#DataView> on top of the data table for splitting those values.
2. If you are using a visualization gadget (which I think is the case), your best shot it to using a script<http://code.google.com/googleapps/appsscript/> . Hope this helps. On Mon, Feb 7, 2011 at 4:45 PM, Howard <[email protected]> wrote: > Hi, > > I am using google forms to collect data from a class of students. > > I want them to be able to add their data as comma separated entries > for each experiment. > > I then want to plot the data as a histogram but to do this I need to > take each cell with the comma separated data in it and put the numbers > into discrete cells. > > What's the best way to go about this please? Is their a function, do I > need to use a script, can I use a query from a google gadget? > > Regards, Howard > > -- > You received this message because you are subscribed to the Google Groups > "Google Visualization API" group. > To post to this group, send email to > [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/google-visualization-api?hl=en. > > -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en.
