Here is an example of Line Chart which takes data from spreadsheet to build the chart.
References:
Chart Preview Screenshot:
Spreadsheet Preview screenshot:
Here is the is the spreadsheet preview which serves as the data source for the chart.
Example Code:
//Get the data from spreadsheet
ssID ='SpreadsheetID';//Change it ro yours
var SS = SpreadsheetApp.openById(ssID);
var sheet = SS.getSheets()[0];
var data = sheet.getRange('A1:G7').getValues();
var dataTable = Charts.newDataTable();
dataTable.addColumn(Charts.ColumnType.STRING, data[0][0]);
for(var i=1; i<data[0].length-1; i++){
dataTable.addColumn(Charts.ColumnType.NUMBER, data[0][i]);
for(var j=1; j<data.length; j++){
dataTable.addRow(data[j]);
var chart = Charts.newLineChart()
.setTitle("Sales by store")
var app = UiApp.createApplication().setTitle("AST Chart");
|