问Google电子表格脚本中图表命名范围的问题

EN

function check() {

 var sheet = SpreadsheetApp.getActiveSheet();
    var end = sheet.getLastRow();
    var start = (end - 5); 
    var endnew = (end - 4);
    var startnew = (end - 6);

     if(sheet.getCharts().length == 0){    
     Logger.log("Er is geen grafiek");
     var chartBuilder = sheet.newChart()
     .asColumnChart().setStacked()
     .addRange(sheet.getRange("A" + startnew + ":" + "A" + endnew)) // should have a name
     .addRange(sheet.getRange("B" + startnew + ":" + "B" + endnew)) // should have a name
     .addRange(sheet.getRange("E" + startnew + ":" + "E" + endnew)) //should have a name
     .setOption('title', 'Effectief gebruik kantoorruimte') //not working
     .setPosition(10, 10, 0, 0)

     var chart = chartBuilder.build();
     sheet.insertChart(chart);    
  }

  else{
Logger.log("Er is wel een grafiek");
var charts = sheet.getCharts();
for (var i in charts) {
  var chart = charts[i];
  var ranges = chart.getRanges();
  var builder = chart.modify();
  for (var j in ranges) {
    var range = ranges[j];
    builder.removeRange(range);

    builder
    .addRange(sheet.getRange("A" + (start) + ":" + "A" + end)) //should have a name
    .addRange(sheet.getRange("B" + (start) + ":" + "B" + end)) //should have a name
    .addRange(sheet.getRange("E" + (start) + ":" + "E" + end))  // should have a name
    .setOption('title', 'Effectief gebruik kantoorruimte')
    .build();
    sheet.updateChart(builder.build());  

   }
    }
  }

}