TypeScript Code

link - learn.microsoft.com/en-us/office/dev/add-ins/excel/excel-add-ins-charts

Read all charts on active worksheet

Excel.run(function (context) { 
    var _charts = context.workbook.worksheets.getActiveWorksheet().charts.load("name"); 
    return context.sync().then(function () { 
        for (var i = 0; i < _charts.items.length; i++) { 
          console.log(_charts.items[i].name); 
        } 
        console.log("done"); 
    }); 
}).catch(function (error) { 
   console.log(error); 
}); 

Add Data

Excel.run(function (context) { 
    var _sheet = context.workbook.worksheets.getActiveWorksheet(); 
    var _rangeCategories = _sheet.getRange("A2:A5"); 
    _rangeCategories.values = [ 
                    [ "Category 1" ], 
                    [ "Category 2" ], 
                    [ "Category 3" ], 
                    [ "Category 4" ] 
    ]; 
    var _rangeSeries = _sheet.getRange("B1:D1"); 
    _rangeSeries.values = [ 
        [ "Series 1", "Series 2", "Series 3", ] 
    ];  
    var _rangeData = sheet.getRange("B2:D5"); 
    _rangeData.formulas = "=RAND()*17"; 
    _rangeData.numberFormat = "#0"; 
    return context.sync();             
}).catch(function (error) { 
   console.log(error); 
}); 

Excel.run(function (context) { 
   context.workbook.worksheets.getItem("Sheet1").charts.add("ColumnClustered", "Sheet1!A1:D5", Excel.ChartSeriesBy.auto); 
}).catch(function (error) { 
   console.log(error); 
}); 

Create New

Excel.run(function (context) { 
   var _range = context.workbook.names.getItem("MyChartData").getRange(); 
   var _chart = context.workbook.worksheets.getItem("Sheet1").charts.add(Excel.ChartType.pie, _range, Excel.ChartSeriesBy.auto); 
   return context.sync(); 
}).catch(function (error) { 
   console.log(error); 
}); 

Charts - Rename

Excel.run(function (context) { 
   context.workbook.worksheets.getActiveWorksheet().charts.getItemAt(0).name = "Chart1"; 
   return context.sync(); 
}).catch(function (error) { 
   console.log(error); 
}); 

add axis title

Excel.run(function (context) { 
   var _chart = context.workbook.worksheets.getActiveWorksheet().charts.getItemAt(0);           
   _chart.axes.valueAxis.title.text = "Category"; 
   return context.sync(); 
}).catch(function (error) { 
   console.log(error); 
}); 

show data labels

Excel.run(function (context) { 
   var _chart = context.workbook.worksheets.getItem("Sheet1").charts.getItemAt(0); 
   _chart.datalabels.visible = true; 
   return context.sync(); 
}).catch(function (error) { 
   console.log(error); 
}); 

show data labels series name

Excel.run(function (context) { 
   var _chart = context.workbook.worksheets.getActiveWorksheet().charts.getItemAt(0);           
   _chart.dataLabels.showSeriesName = true; 
   return context.sync();             
}).catch(function (error) { 
   console.log(error); 
}); 

change data labels position

Excel.run(function (context) { 
   var _chart = context.workbook.worksheets.getActiveWorksheet().charts.getItemAt(0);           
   _chart.dataLabels.position = Excel.ChartDataLabelPosition.top; 
   return context.sync();             
}).catch(function (error) { 
   console.log(error); 
}); 

get chart by name

Excel.run(function (context) { 
   var _chart = context.workbook.worksheets.getActiveWorksheet().charts.getItem("Chart1"); 
   _chart.load("name"); 
   return context.sync().then(function () { 
      console.log(_chart.name);                             
   }); 
}).catch(function (error) { 
   console.log(error); 
}); 

get chart title

Excel.run(function (context) { 
   var _charttitle = context.workbook.worksheets.getActiveWorksheet().charts.getItemAt(0).title.load("text"); 
   return context.sync().then(function() { 
      console.log(_charttitle.text); 
   }); 
}).catch(function (error) { 
   console.log(error); 
}); 

change chart background color

Excel.run(function (context) { 
   var _chart = context.workbook.worksheets.getActiveWorksheet().charts.getItemAt(0);           
   _chart.format.fill.setSolidColor("#FF0000");           
   return context.sync(); 
}).catch(function (error) { 
   console.log(error); 
}); 

change series border color

Excel.run(function (context) { 
   var _chart = context.workbook.worksheets.getActiveWorksheet.charts.getItemAt(0);              
   _chart.series.getItemAt(0).lineFormat.color = "#FF0000"; 
   return context.sync();             
}).catch(function (error) { 
   console.log(error); 
}); 

change series fill color

Excel.run(function (context) { 
   var _chart = context.workbook.worksheets.getActiveWorksheet().charts.getItemAt(0);           
   _chart.series.getItemAt(0).format.fill.setSolidColor("#FF0000"); 
   return context.sync(); 
}).catch(function (error) { 
   console.log(error); 
}); 

configure axis

Excel.run(function (context) { 
   var _chart = context.workbook.worksheets.getActiveWorksheet().charts.getItemAt(0);           
   _chart.axes.valueAxis.maximum = 5; 
   _chart.axes.valueAxis.minimum = 0; 
   _chart.axes.valueAxis.majorUnit = 1; 
   _chart.axes.valueAxis.minorUnit = 0.2; 
   return context.sync();             
}).catch(function (error) { 
   console.log(error); 
}); 

format chart title

Excel.run(function (context) { 
   var _chart = context.workbook.worksheets.getActiveWorksheet().charts.getItemAt(0); 
   _chart.title.format.font.bold = true; 
   _chart.title.format.font.color = "#FF0000"; 
   return context.sync();                             
}).catch(function (error) { 
   console.log(error); 
}); 

create and format chart

Excel.run(function (context) { 
    var _sheet = context.workbook.worksheets.getItem("Sheet1"); 
    var _range = _sheet.getRange("A1:B3"); 
    _range.values = [ 
                    ["", "Gender"], 
                    ["Male", 12], 
                    ["Female", 14] 
    ]; 
    var _chart = sheet.charts.add("pie", _range, "auto"); 
    _chart.format.fill.setSolidColor("F8F8FF"); 
    _chart.title.text = "Class Demographics"; 
    _chart.title.format.font.bold = true; 
    _chart.title.format.font.size = 18; 
    _chart.title.format.font.color = "568568"; 
    _chart.legend.position = "right"; 
    _chart.legend.format.font.name = "Algerian"; 
    _chart.legend.format.font.size = 13; 
    _chart.dataLabels.showPercentage = true; 
    _chart.dataLabels.format.font.size = 15; 
    _chart.dataLabels.format.font.color = "444444"; 
    var _points = _chart.series.getItemAt(0).points; 
    _points.getItemAt(0).format.fill.setSolidColor("8FBC8F"); 
    _points.getItemAt(1).format.fill.setSolidColor("D87093"); 
    return context.sync(); 
}).catch(function (error) { 
   console.log(error); 
}); 

resize chart

Excel.run(function (context) { 
   var _chart = context.workbook.worksheets.getItem("Sheet1").charts.getItemAt(0);  
   _chart.height = 200; 
   _chart.width = 200; 
   return context.sync(); 
}).catch(function (error) { 
   console.log(error); 
}); 

set chart position

Excel.run(function (context) { 
   var _chart = context.workbook.worksheets.getActiveWorksheet().charts.getItemAt(0);           
   _chart.top = 200; 
   _chart.left = 200; 
   return context.sync(); 
}).catch(function (error) { 
   console.log(error); 
}); 

set seriesby

Excel.run(function (context) { 
   var _chart = context.workbook.worksheets.getItem("Sheet1").charts.getItemAt(0);  
   _chart.setData("Sheet1!A1:B4", Excel.ChartSeriesBy.rows); 
   return context.sync(); 
}).catch(function (error) { 
   console.log(error); 
}); 

show legend

Excel.run(function (context) { 
   var _chart = context.workbook.worksheets.getActiveWorksheet().charts.getItemAt(0);           
   _chart.legend.visible = true; 
   return context.sync(); 
}).catch(function (error) { 
   console.log(error); 
}); 

show majorgridlines

Excel.run(function (context) { 
   var _chart = context.workbook.worksheets.getActiveWorksheet().charts.getItemAt(0);           
   _chart.axes.valueAxis.majorGridlines.visible = true; 
   return context.sync(); 
}).catch(function (error) { 
   console.log(error); 
}); 

set chart data source

Excel.run(function (context) { 
   var _chart = context.workbook.worksheets.getItem("Sheet1").charts.getItemAt(0);  
   _chart.setData("Sheet1!A1:B4", Excel.ChartSeriesBy.columns); 
   return context.sync();             
}).catch(function (error) { 
   console.log(error); 
}); 

hide axis title

Excel.run(function (context) { 
   var _chart = context.workbook.worksheets.getActiveWorksheet().charts.getItemAt(0);           
   _chart.axes.valueAxis.title.visible = false; 
   return context.sync(); 
}).catch(function (error) { 
   console.log(error); 
}); 

delete chart

Excel.run(function (context) { 
   context.workbook.worksheets.getActiveWorksheet().charts.getItemAt(0).delete(); 
   return context.sync(); 
}).catch(function (error) { 
   console.log(error); 
}); 

Hide chart title

Excel.run(function (context) { 
   context.workbook.worksheets.getActiveWorksheet().charts.getItemAt(0).title.visible = false; 
   return context.sync();             
}).catch(function (error) { 
   console.log(error); 
}); 

Changing the height and width

var chart = context.charts.add(Excel.ChartType.ColumnClustered,,,,) 
chart.name = 
chart.setPosition('B2')  
chart.height = 200 
chart.width = 200