Hi,
I have been using the Google Chart API in Apps Script to build dashboards.
So, far I have drawn the data from the spreadsheet by using .openById type.
However, I would like to use Combo, 100% stacked and motion charts and is
there a way I can still connect my dashboard/charts to the google
spreadsheet instead of manually typing in the data such as arraytoDataTable
method?
var data = google.visualization.arrayToDataTable
In all the examples mentioned in the Google Code Playground, the data has
been mentioned
in the charts which is fine as an example but for spreadsheet with 900 rows
and
columns, manually typing in the data may not be the best method. Any
workaround assuming
I still want to host the data on a Google spreadsheet?
*My current version*
var ss =
SpreadsheetApp.openById('0AmSp_yYHF4BrdGlOYVpMOW1reGgzcjNKQy1BYZ0tS3c');
var data = ss.getDataRange();
var tableChart = Charts.newTableChart()
.setDataViewDefinition(Charts.newDataViewDefinition().setColumns([1,2,3,4,5,6,7,8,9,10]))
.build();
Best,
Samantak
--
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/groups/opt_out.
