CreateChart
function CreateChart(
sType: ChartType = "bar",
aSeries: [] = null,
aSeriesNames: [] = null,
aCatNames: [] = null,
nWidth: EMU = null,
nHeight: EMU = null,
nStyleIndex: number = null,
aNumFormats: NumFormat[] | String[] = null,
): ApiChartDescription
Creates a chart with the parameters specified.
Parameters
The chart type used for the chart display.
- aSeries
[]default: null The array of the data used to build the chart from.
- aSeriesNames
[]default: null The array of the names (the source table column names) used for the data which the chart will be build from.
- aCatNames
[]default: null The array of the names (the source table row names) used for the data which the chart will be build from.
The chart width in English measure units.
The chart height in English measure units.
- nStyleIndex
numberdefault: null The chart color style index (can be 1 - 48, as described in OOXML specification).
Numeric formats which will be applied to the series (can be custom formats). The default numeric format is "General".
Returns
ApiChartTry It
var oDocument = Api.GetDocument();
var oParagraph = oDocument.GetElement(0);
var oChart = Api.CreateChart("bar3D", [
[200, 240, 280],
[250, 260, 280]
], ["Projected Revenue", "Estimated Costs"], [2014, 2015, 2016], 4051300, 2347595, 24);
oParagraph.AddDrawing(oChart);
var oFill = Api.CreateSolidFill(Api.CreateRGBColor(51, 51, 51));
oChart.SetSeriesFill(oFill, 0, false);
oFill = Api.CreateSolidFill(Api.CreateRGBColor(255, 111, 61));
oChart.SetSeriesFill(oFill, 1, false);