Excel.Interfaces.ChartDataLabelsLoadOptions interface

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

[ API set: ExcelApi 1.1 ]

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

autoText

Represents whether data labels automatically generate appropriate text based on context.

[ API set: ExcelApi 1.8 ]

format

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

[ API set: ExcelApi 1.1 ]

horizontalAlignment

Represents the horizontal alignment for chart data label. See Excel.ChartTextHorizontalAlignment for details. This property is valid only when TextOrientation of data label is 0.

[ API set: ExcelApi 1.8 ]

linkNumberFormat

Represents whether or not the number format is linked to the cells. If true, the number format will change in the labels when it changes in the cells

[ API set: ExcelApi 1.9 ]

numberFormat

Represents the format code for data labels.

[ API set: ExcelApi 1.8 ]

position

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

[ API set: ExcelApi 1.1 ]

separator

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

[ API set: ExcelApi 1.1 ]

showBubbleSize

Boolean value representing if the data label bubble size is visible or not.

[ API set: ExcelApi 1.1 ]

showCategoryName

Boolean value representing if the data label category name is visible or not.

[ API set: ExcelApi 1.1 ]

showLegendKey

Boolean value representing if the data label legend key is visible or not.

[ API set: ExcelApi 1.1 ]

showPercentage

Boolean value representing if the data label percentage is visible or not.

[ API set: ExcelApi 1.1 ]

showSeriesName

Boolean value representing if the data label series name is visible or not.

[ API set: ExcelApi 1.1 ]

showValue

Boolean value representing if the data label value is visible or not.

[ API set: ExcelApi 1.1 ]

textOrientation

Represents the text orientation of data labels. The value should be an integer either from -90 to 90, or 180 for vertically-oriented text.

[ API set: ExcelApi 1.8 ]

verticalAlignment

Represents the vertical alignment of chart data label. See Excel.ChartTextVerticalAlignment for details. This property is valid only when TextOrientation of data label is -90, 90, or 180.

[ API set: ExcelApi 1.8 ]

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

autoText

Represents whether data labels automatically generate appropriate text based on context.

[ API set: ExcelApi 1.8 ]

autoText?: boolean;

Property Value

boolean

format

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

[ API set: ExcelApi 1.1 ]

format?: Excel.Interfaces.ChartDataLabelFormatLoadOptions;

Property Value

horizontalAlignment

Represents the horizontal alignment for chart data label. See Excel.ChartTextHorizontalAlignment for details. This property is valid only when TextOrientation of data label is 0.

[ API set: ExcelApi 1.8 ]

horizontalAlignment?: boolean;

Property Value

boolean

linkNumberFormat

Represents whether or not the number format is linked to the cells. If true, the number format will change in the labels when it changes in the cells

[ API set: ExcelApi 1.9 ]

linkNumberFormat?: boolean;

Property Value

boolean

numberFormat

Represents the format code for data labels.

[ API set: ExcelApi 1.8 ]

numberFormat?: boolean;

Property Value

boolean

position

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

[ API set: ExcelApi 1.1 ]

position?: boolean;

Property Value

boolean

separator

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

[ API set: ExcelApi 1.1 ]

separator?: boolean;

Property Value

boolean

showBubbleSize

Boolean value representing if the data label bubble size is visible or not.

[ API set: ExcelApi 1.1 ]

showBubbleSize?: boolean;

Property Value

boolean

showCategoryName

Boolean value representing if the data label category name is visible or not.

[ API set: ExcelApi 1.1 ]

showCategoryName?: boolean;

Property Value

boolean

showLegendKey

Boolean value representing if the data label legend key is visible or not.

[ API set: ExcelApi 1.1 ]

showLegendKey?: boolean;

Property Value

boolean

showPercentage

Boolean value representing if the data label percentage is visible or not.

[ API set: ExcelApi 1.1 ]

showPercentage?: boolean;

Property Value

boolean

showSeriesName

Boolean value representing if the data label series name is visible or not.

[ API set: ExcelApi 1.1 ]

showSeriesName?: boolean;

Property Value

boolean

showValue

Boolean value representing if the data label value is visible or not.

[ API set: ExcelApi 1.1 ]

showValue?: boolean;

Property Value

boolean

textOrientation

Represents the text orientation of data labels. The value should be an integer either from -90 to 90, or 180 for vertically-oriented text.

[ API set: ExcelApi 1.8 ]

textOrientation?: boolean;

Property Value

boolean

verticalAlignment

Represents the vertical alignment of chart data label. See Excel.ChartTextVerticalAlignment for details. This property is valid only when TextOrientation of data label is -90, 90, or 180.

[ API set: ExcelApi 1.8 ]

verticalAlignment?: boolean;

Property Value

boolean