Excel.Interfaces.ChartDataLabelsUpdateData interface

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

Properties

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

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.ChartDataLabelFormatUpdateData;

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?: Excel.ChartTextHorizontalAlignment | "Center" | "Left" | "Right" | "Justify" | "Distributed";

Property Value

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

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?: string;

Property Value

string

position

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

[ API set: ExcelApi 1.1 ]

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 labels on a chart.

[ API set: ExcelApi 1.1 ]

separator?: string;

Property Value

string

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

[ API set: ExcelApi 1.8 ]

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

Property Value

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