kitakita - 経済統計練習帳

function myPIEChartFunction() {
  var sheet=SpreadsheetApp.getActiveSheet();
  var range=sheet.getRange(1,1,6,2);
 
  sheet.getRange(1,1).setValue("neko");
  sheet.getRange(1,2).setValue("dog");
 
  var chart=sheet.newChart()
    .addRange(range)
    .setChartType(Charts.ChartType.LINE)
    .setPosition(4,3,0,0)
    .setOption('title','練習');
 
  sheet.insertChart(chart.build());
}