Excel.Interfaces.ChartDataLabelLoadOptions 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

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

position?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.7 ]

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

separator?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.7 ]

Specifies if the data label bubble size is visible.

showBubbleSize?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.7 ]

Specifies if the data label category name is visible.

showCategoryName?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.7 ]

Specifies if the data label legend key is visible.

showLegendKey?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.7 ]

Specifies if the data label percentage is visible.

showPercentage?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.7 ]

Specifies if the data label series name is visible.

showSeriesName?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.7 ]

Specifies if the data label value is visible.

showValue?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.7 ]