CreateChart
Creates a chart with the parameters specified.
Parameters:
| Name |
Type |
Default |
Description |
| sType |
ChartType
|
"bar" |
The chart type used for the chart display. |
| aSeries |
Array
|
|
The array of the data used to build the chart from. |
| aSeriesNames |
Array
|
|
The array of the names (the source table column names) used for the data which the chart will be build from. |
| aCatNames |
Array
|
|
The array of the names (the source table row names) used for the data which the chart will be build from. |
| nWidth |
EMU
|
|
The chart width in English measure units. |
| nHeight |
EMU
|
|
The chart height in English measure units. |
| nStyleIndex |
number
|
|
The chart color style index (can be 1 - 48, as described in OOXML specification). |
| aNumFormats |
Array.<NumFormat> | Array.<String>
|
|
Numeric formats which will be applied to the series (can be custom formats).
The default numeric format is "General". |
Returns:
- Type
-
ApiChart
Example
Copy code
builder.CreateFile("docx");
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);
builder.SaveFile("docx", "CreateChart.docx");
builder.CloseFile();
Resulting document