ｈｇｇ - 経済統計練習帳

function myFunction() {
 
 
 
 
    id="1LYU0JMfI8FV1eDxT0MD2fCqMbisEvZfX9aWj4RQJFqY";
 
 var ex1 = SpreadsheetApp.openById(id);
 var sheet = ex1.getSheetByName("data");
 
 
  var chartRange = sheet.getRange(1, 1, 4, 2);
  var chartBuilder = sheet.newChart();
  chartBuilder.addRange(chartRange)
  .setChartType(Charts.ChartType.PIE)
  .setOption('title', 'My Chart!')
  .setPosition(1, 1, 20, 20); 
  sheet.insertChart(chartBuilder.build());
 
 
 
}