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