Excel.Interfaces.ChartDataLabelsLoadOptions interface

Specifying $all for the load options loads all the scalar properties (such as Range.address) but not the navigational properties (such as Range.format.fill.color).

$all?: boolean;

Property Value

Specifies the format of chart data labels, which includes fill and font formatting.

format?: Excel.Interfaces.ChartDataLabelFormatLoadOptions;

Property Value

Remarks

[ API set: ExcelApi 1.1 ]

Value that represents the position of the data label. See Excel.ChartDataLabelPosition for details.

position?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.1 ]

String representing the separator used for the data labels on a chart.

separator?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.1 ]

Specifies if the data label bubble size is visible.

showBubbleSize?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.1 ]

Specifies if the data label category name is visible.

showCategoryName?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.1 ]

Specifies if the data label legend key is visible.

showLegendKey?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.1 ]

Specifies if the data label percentage is visible.

showPercentage?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.1 ]

Specifies if the data label series name is visible.

showSeriesName?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.1 ]

Specifies if the data label value is visible.

showValue?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.1 ]