试试看：

Excel.run(function (context) {
    // Get the active worksheet
    var sheet = context.workbook.worksheets.getActiveWorksheet();
    // Define the data range for the PivotTable
    var dataRange = sheet.getRange("A1:C10");
    // Create a PivotTable based on the data range
    var pivotTable = sheet.pivotTables.add("A15", dataRange, true);
    // Define the data range for the PivotChart
    var chartRange = sheet.getRange("E1:F10");
    // Create a PivotChart based on the PivotTable and data range
    var pivotChart = sheet.charts.add("A30", Excel.ChartType.columnClustered, pivotTable);
    pivotChart.setSourceData(chartRange);
    // Synchronize the changes with the workbook
    return context.sync();
}).catch(function (error) {
    console.log(error);
});