It is certainly possible.
Just replace the code that assembles the datatable locally ('prepare the
data' section) with a google.visualization.Query directed toward the
spreadsheet containing the data you want to visualize. You can then use the
rest of the example you posted with the datatable returned in the query
response.
An example about issuing queries to spreadsheets:
http://code.google.com/apis/ajax/playground/?type=visualization#data_source_request
( in your case, you'll have to plug the ControlWrapper and ChartWrapper
creation after the 'response.getDataTable()' line)
Documentation about issuing queries:
http://code.google.com/apis/chart/interactive/docs/queries.html
and instructions on how to extract the query URL from your spreadsheet
(which you will then feed to google.visualization.Query):
http://code.google.com/apis/chart/interactive/docs/spreadsheets.html
Hope this helps,
/R.
--
You received this message because you are subscribed to the Google Groups
"Google Visualization API" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/google-visualization-api/-/8768YK7XXqoJ.
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.
