Edit

Share via

Excel.Interfaces.ChartDataLabelsLoadOptions interface

  • Reference
Package:
excel

Represents a collection of all the data labels on a chart point.

Remarks

[ API set: ExcelApi 1.1 ]

Properties

$all

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).
format

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

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

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

Specifies if the data label bubble size is visible.
showCategoryName

Specifies if the data label category name is visible.
showLegendKey

Specifies if the data label legend key is visible.
showPercentage

Specifies if the data label percentage is visible.
showSeriesName

Specifies if the data label series name is visible.
showValue

Specifies if the data label value is visible.

Property Details

$all

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

boolean

format

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

format?: Excel.Interfaces.ChartDataLabelFormatLoadOptions;

Property Value

Excel.Interfaces.ChartDataLabelFormatLoadOptions

Remarks

[ API set: ExcelApi 1.1 ]

position

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

position?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.1 ]

separator

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

separator?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.1 ]

showBubbleSize

Specifies if the data label bubble size is visible.

showBubbleSize?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.1 ]

showCategoryName

Specifies if the data label category name is visible.

showCategoryName?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.1 ]

showLegendKey

Specifies if the data label legend key is visible.

showLegendKey?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.1 ]

showPercentage

Specifies if the data label percentage is visible.

showPercentage?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.1 ]

showSeriesName

Specifies if the data label series name is visible.

showSeriesName?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.1 ]

showValue

Specifies if the data label value is visible.

showValue?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.1 ]