Chart Services‎ > ‎

Scatter Chart

Scatter charts are used to show trends in data. They are especially useful when you have a large number of data points. Like line charts, they can be used to plot data recorded from scientific experiments, such as how a chemical reacts to changing temperature or atmospheric pressure.
Here is an example of Scatter Chart which takes data from spreadsheet to build the chart.


Spreadsheet Preview screenshot:

Here is the is the spreadsheet preview which serves as the data source for the chart.
Scatter Chart Data source


Example Code:
function doGet(){
  //Get the data from spreadsheet
  ssID ='SpreadsheetID'//Change it to yours
  var SS = SpreadsheetApp.openById('ssID');
  var sheet = SS.getSheets()[0];
var data = sheet.getRange('A1:B10').getValues();
  //Build data table
  var dataTable = Charts.newDataTable();
  dataTable.addColumn(Charts.ColumnType.NUMBER, data[0][0]);
  dataTable.addColumn(Charts.ColumnType.NUMBER, data[0][1]);
  //Add rows
  for(var j=1; j<data.length; j++){
  //Create and build chart
  var chart = Charts.newScatterChart()
      .setYAxisRange(0, 140)
      .setTitle("Particulate levels in Rainfall")
  var app = UiApp.createApplication().setTitle("AST Chart");
  return app;