Interface DataTableSource

 // Opens the spreadsheet file by its ID. If you created your script from a 
 // Google Sheets file, use SpreadsheetApp.getActiveSpreadsheet(). 
 // TODO(developer): Replace the ID with your own. 
 const 
  
 ss 
  
 = 
  
 SpreadsheetApp 
 . 
 openById 
 ( 
 'abc123456' 
 ); 
 // Gets Sheet1 by its name. 
 const 
  
 sheet 
  
 = 
  
 ss 
 . 
 getSheetByName 
 ( 
 'Sheet1' 
 ); 
 // Gets the range A1:B7 on Sheet1. 
 const 
  
 range 
  
 = 
  
 sheet 
 . 
 getRange 
 ( 
 'A1:B7' 
 ); 
 // Gets the range A1:B7 as a data table. The values in each column must be of 
 // the same type. 
 const 
  
 datatable 
  
 = 
  
 range 
 . 
 getDataTable 
 (); 
 // Uses the Charts service to build a bar chart from the data table. 
 // This doesn't build an embedded chart. To do that, use 
 // sheet.newChart().addRange() instead. 
 const 
  
 chart 
  
 = 
  
 Charts 
 . 
 newBarChart 
 () 
  
 . 
 setDataTable 
 ( 
 datatable 
 ) 
  
 . 
 setOption 
 ( 
 'title' 
 , 
  
 'Your Chart Title Here' 
 ) 
  
 . 
 build 
 ();