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(4,3,0,0) .setOption('title','練習'); sheet.insertChart(chart.build()); }