Hi Samantak,
I am also doing analytics api and would like to plot various charts.
Please let me know, how you pur data in shpreadsheet and useing same
data to plot chart.
Thanks.
On Monday, July 8, 2013 11:21:18 AM UTC+5:30, Samantak Bagchi wrote:
> 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.
