/**
* Copy a chart to the spreadsheet
*
* @param {GoogleAppsScript.Charts.Chart} chart The chart
* @param {GoogleAppsScript.Spreadsheet.Sheet} sheet The destination sheet
* @return {GoogleAppsScript.Charts.Chart} The new copy of the chart
*/
function copyChart_(chart, sheet) {
    var spreadsheet = sheet.getParent();
    var builder = chart.modify();
    builder.clearRanges();
    chart.getRanges().forEach(function(range) {
        var sheetName = range.getSheet().getName();
        var nota = range.getA1Notation();
        var sheet =
            spreadsheet.getSheetByName(sheetName) ||
            spreadsheet.insertSheet(sheetName);
        builder.addRange(sheet.getRange(nota));
    });

    var copyChart = builder.build();
    sheet.insertChart(copyChart);
    return copyChart;
}