SetDataPointNumFormat

function SetDataPointNumFormat(
  sFormat: NumFormat | String = null,
  nSeria: Number = null,
  nDataPoint: number = null,
  bAllSeries: boolean = null,
): boolean

Description

Sets the specified numeric format to the chart data point.

Parameters

sFormatNumFormat | Stringdefault: null

Numeric format (can be custom format).

nSeriaNumberdefault: null

Series index.

nDataPointnumberdefault: null

The index of the data point in the specified chart series.

bAllSeriesbooleandefault: null

Specifies if the numeric format will be applied to the specified data point in all series.

Returns

boolean

Try It

var oPresentation = Api.GetPresentation();
var oSlide = oPresentation.GetSlideByIndex(0);
oSlide.RemoveAllObjects();
var oChart = Api.CreateChart("bar3D", [
   [200, 240, 280],
   [250, 260, 280]
], ["Projected Revenue", "Estimated Costs"], [2014, 2015, 2016], 4051300, 2347595, 24, ["0", "0.00"]);
oChart.SetSize(300 * 36000, 130 * 36000);
oChart.SetPosition(608400, 1267200);
oChart.SetShowPointDataLabel(1, 0, false, false, true, false);
oChart.SetDataPointNumFormat("0.00", 0, 0, true);
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);
oSlide.AddObject(oChart);

Get Help

  • If you have any questions about ONLYOFFICE Docs, try the FAQ section first.
  • You can request a feature or report a bug by posting an issue on GitHub.
  • You can also ask our developers on ONLYOFFICE forum (registration required).