Excel.Interfaces.ChartDataLabelUpdateData interface

An interface for updating data on the ChartDataLabel object, for use in "chartDataLabel.set({ ... })".

Properties

autoText

Boolean value representing if data label automatically generates appropriate text based on context.

[ API set: ExcelApi 1.8 ]

format

Represents the format of chart data label.

[ API set: ExcelApi 1.8 ]

formula

String value that represents the formula of chart data label using A1-style notation.

[ API set: ExcelApi 1.8 ]

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 90, -90 or 180.

[ API set: ExcelApi 1.8 ]

left

Represents the distance, in points, from the left edge of chart data label to the left edge of chart area. Null if chart data label is not visible.

[ API set: ExcelApi 1.8 ]

linkNumberFormat

Boolean value representing if the number format is linked to the cells (so that the number format changes in the labels when it changes in the cells).

[ API set: ExcelApi 1.9 ]

numberFormat

String value that represents the format code for data label.

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

separator

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

[ API set: ExcelApi 1.7 ]

showBubbleSize

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

[ API set: ExcelApi 1.7 ]

showCategoryName

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

[ API set: ExcelApi 1.7 ]

showLegendKey

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

[ API set: ExcelApi 1.7 ]

showPercentage

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

[ API set: ExcelApi 1.7 ]

showSeriesName

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

[ API set: ExcelApi 1.7 ]

showValue

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

[ API set: ExcelApi 1.7 ]

text

String representing the text of the data label on a chart.

[ API set: ExcelApi 1.8 ]

textOrientation

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

[ API set: ExcelApi 1.8 ]

top

Represents the distance, in points, from the top edge of chart data label to the top of chart area. Null if chart data label is not visible.

[ 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 0.

[ API set: ExcelApi 1.8 ]

Property Details

autoText

Boolean value representing if data label automatically generates appropriate text based on context.

[ API set: ExcelApi 1.8 ]

autoText?: boolean;

Property Value

boolean

format

Represents the format of chart data label.

[ API set: ExcelApi 1.8 ]

format?: Excel.Interfaces.ChartDataLabelFormatUpdateData;

Property Value

formula

String value that represents the formula of chart data label using A1-style notation.

[ API set: ExcelApi 1.8 ]

formula?: string;

Property Value

string

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 90, -90 or 180.

[ API set: ExcelApi 1.8 ]

horizontalAlignment?: Excel.ChartTextHorizontalAlignment | "Center" | "Left" | "Right" | "Justify" | "Distributed";

Property Value

Excel.ChartTextHorizontalAlignment | "Center" | "Left" | "Right" | "Justify" | "Distributed"

left

Represents the distance, in points, from the left edge of chart data label to the left edge of chart area. Null if chart data label is not visible.

[ API set: ExcelApi 1.8 ]

left?: number;

Property Value

number

linkNumberFormat

Boolean value representing if the number format is linked to the cells (so that the number format changes in the labels when it changes in the cells).

[ API set: ExcelApi 1.9 ]

linkNumberFormat?: boolean;

Property Value

boolean

numberFormat

String value that represents the format code for data label.

[ API set: ExcelApi 1.8 ]

numberFormat?: string;

Property Value

string

position

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

[ API set: ExcelApi 1.7 ]

position?: Excel.ChartDataLabelPosition | "Invalid" | "None" | "Center" | "InsideEnd" | "InsideBase" | "OutsideEnd" | "Left" | "Right" | "Top" | "Bottom" | "BestFit" | "Callout";

Property Value

Excel.ChartDataLabelPosition | "Invalid" | "None" | "Center" | "InsideEnd" | "InsideBase" | "OutsideEnd" | "Left" | "Right" | "Top" | "Bottom" | "BestFit" | "Callout"

separator

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

[ API set: ExcelApi 1.7 ]

separator?: string;

Property Value

string

showBubbleSize

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

[ API set: ExcelApi 1.7 ]

showBubbleSize?: boolean;

Property Value

boolean

showCategoryName

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

[ API set: ExcelApi 1.7 ]

showCategoryName?: boolean;

Property Value

boolean

showLegendKey

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

[ API set: ExcelApi 1.7 ]

showLegendKey?: boolean;

Property Value

boolean

showPercentage

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

[ API set: ExcelApi 1.7 ]

showPercentage?: boolean;

Property Value

boolean

showSeriesName

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

[ API set: ExcelApi 1.7 ]

showSeriesName?: boolean;

Property Value

boolean

showValue

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

[ API set: ExcelApi 1.7 ]

showValue?: boolean;

Property Value

boolean

text

String representing the text of the data label on a chart.

[ API set: ExcelApi 1.8 ]

text?: string;

Property Value

string

textOrientation

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

[ API set: ExcelApi 1.8 ]

textOrientation?: number;

Property Value

number

top

Represents the distance, in points, from the top edge of chart data label to the top of chart area. Null if chart data label is not visible.

[ API set: ExcelApi 1.8 ]

top?: number;

Property Value

number

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

[ API set: ExcelApi 1.8 ]

verticalAlignment?: Excel.ChartTextVerticalAlignment | "Center" | "Bottom" | "Top" | "Justify" | "Distributed";

Property Value

Excel.ChartTextVerticalAlignment | "Center" | "Bottom" | "Top" | "Justify" | "Distributed"