How can update data range of combo chart by Google App Script?

In a Google Sheet, i have 2 charts: a Combo chart, a Pie Chart

Data Range of Combo chart: C51:O57,Q51:AB58,AD51:AO58,AQ51:BB58,BD51:BO58,BQ51:CB58,CD51:CO58
and Combine Range is Horizontally

Data Range of Pie Chart: A51:A55,CQ51:CQ55
and Combine Range is Horizontally

I want update Data Range of 2 Charts:

Combo chart: add Range "CQ51:DB58"

Pie Chart: replace "CQ51:CQ55" to "DD51:DD55"

I had try this code:

Pie Chart update ok.

Combo chart occur error: Exception: Service Spreadsheets failed while accessing document with id

    var oSpreadSheet = SpreadsheetApp.getActiveSpreadsheet(); 
    var sheet_Des=oSpreadSheet.getSheetByName("Sheet1");
    var charts = sheet_Des.getCharts();

    //Pie Chart 
   var chart = charts[1];
   var ranges = chart.getRanges();
   var newRange=sheet_Des.getRange(51,108 ,5,1);
  // var  rangename=newRange.getA1Notation();
   var chart = chart.modify()
          .removeRange(ranges[1])          
          .addRange(newRange)
          .build();
   sheet_Des.updateChart(chart);

    //Combo Chart 
    chart = charts[0];
    ranges = chart.getRanges();
    newRange=sheet_Des.getRange(51,95 ,8,12);
    // var  rangename2=newRange.getA1Notation();
    chart = chart.modify()          
          .addRange(newRange)
          .build();       
    sheet_Des.updateChart(chart);

Why can't update data range of Combo chart?

I tested your script and I got the same error. This seems to be an issue, I found similar reports on Google's Issue Tracker, this is another sample. You can add comments on both issues to ask for updates or check if someone else found a workarond.

A workaround that worked for me, is deleting the chart and creating a new one, I used the following script:

function createChart() {
  var oSpreadSheet = SpreadsheetApp.getActiveSpreadsheet(); 
  var sheet_Des=oSpreadSheet.getSheetByName("Sheet1");
  var charts = sheet_Des.getCharts();

  //Pie Chart 
  var chart = charts[1];
  var ranges = chart.getRanges();
  var newRange=sheet_Des.getRange(51,108 ,5,1);
  // var  rangename=newRange.getA1Notation();
  var chart = chart.modify()
    .removeRange(ranges[1])          
    .addRange(newRange)
    .build();
  sheet_Des.updateChart(chart);

  //Combo Chart 
  chart = charts[0];
  var options = charts[0].getOptions().get('title'); //If you want to copy some options from the Combo Chart before deleting it, you need to get each option in a separate variable
  ranges = chart.getRanges();
  newRange=sheet_Des.getRange(51,95 ,8,12);
  // var  rangename2=newRange.getA1Notation();
  sheet_Des.removeChart(chart);
  chart = sheet_Des.newChart()
    .asComboChart()
    .addRange(newRange)
    .setOption('title',options) //Set the options that you want (title, width, height, etc)
    .build()
  sheet_Des.insertChart(chart.modify().setPosition(43,6,0,0).build()) //Adjust the position where you want to create the Chart
}

UPDATE

This is a sample with the Sheets API. You can click in the JAVASCRIPT tab to get an idea of how you make the request in Apps Script.

Note: If you access the Sheets API using Apps Script, you will have to enable the Advanced Sheets Service.

References:

• newChart()
• insertChart(chart)
• Combo chart configuration options
• UpdateChartSpecRequest
• Enable advanced services