I am trying to load one spreadsheet containing all the data I would need into my document, and choose what to display for a graph. For example, if my data contained columns "month", "severity of weather", "inches of rainfall", and "london/tokyo", I want to be able to display, say, a line chart that shows me the change in rainfall over the months in London. I want to be able to do this without predeclaring the "view" of my chart, allowing flexibility to drill down/ display what the user wants on the go. I found chart editor helpful in choosing different graphs, and I bound my graph(which I initialized as a pie chart) to a couple control widgets to allow me to drill down the data. However, this is a very messy way to do what I want. Can somebody offer some advice to point me in the right direction?
Also, is there a way to add data such as this, without uploading another database? For example, add inches of rainfall over just the first five months, and display that as a bar graph with two categories, London and Tokyo. Clearly I am looking for a way to do all this with one database. Thanks! -- 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. For more options, visit https://groups.google.com/d/optout.
