SetDataPointNumFormat
function SetDataPointNumFormat(
sFormat: NumFormat | String = null,
nSeria: Number = null,
nDataPoint: number = null,
bAllSeries: boolean = null,
): booleanDescription
Sets the specified numeric format to the chart data point.
Parameters
Numeric format (can be custom format).
- nSeria
Numberdefault: null Series index.
- nDataPoint
numberdefault: null The index of the data point in the specified chart series.
- bAllSeries
booleandefault: null Specifies if the numeric format will be applied to the specified data point in all series.
Returns
booleanTry 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);
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);
oChart.SetShowPointDataLabel(1, 0, false, false, true, false);
oChart.SetDataPointNumFormat("0.00", 1, 0, true);
oParagraph.AddDrawing(oChart);