Excel.Interfaces.ChartDataLabelLoadOptions interface

Package:

excel

Represents the data label of a chart point.

Remarks

[ API set: ExcelApi 1.7 ]

Properties

$all	Specifying $all for the LoadOptions loads all the scalar properties (e.g.: Range.address) but not the navigational properties (e.g.: Range.format.fill.color).
position	Value that represents the position of the data label. See Excel.ChartDataLabelPosition for details.
separator	String representing the separator used for the data label 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 LoadOptions loads all the scalar properties (e.g.: Range.address) but not the navigational properties (e.g.: Range.format.fill.color).

$all?: boolean;

Property Value

boolean

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.7 ]

separator

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

separator?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.7 ]

showBubbleSize

Specifies if the data label bubble size is visible.

showBubbleSize?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.7 ]

showCategoryName

Specifies if the data label category name is visible.

showCategoryName?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.7 ]

showLegendKey

Specifies if the data label legend key is visible.

showLegendKey?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.7 ]

showPercentage

Specifies if the data label percentage is visible.

showPercentage?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.7 ]

showSeriesName

Specifies if the data label series name is visible.

showSeriesName?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.7 ]

showValue

Specifies if the data label value is visible.

showValue?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.7 ]