Excel.Interfaces.ChartDataLabelsData interface
Warning
This API is now deprecated.
An interface describing the data returned by calling chartDataLabels.toJSON()
.
Properties
auto |
Specifies if data labels automatically generate appropriate text based on context. |
format | Specifies the format of chart data labels, which includes fill and font formatting. |
horizontal |
Specifies the horizontal alignment for chart data label. See |
link |
Specifies if the number format is linked to the cells. If |
number |
Specifies the format code for data labels. |
position | Value that represents the position of the data label. See |
separator | String representing the separator used for the data labels on a chart. |
show |
Specifies if the data label bubble size is visible. |
show |
Specifies if the data label category name is visible. |
show |
Specifies if the data label legend key is visible. |
show |
Specifies if the data label percentage is visible. |
show |
Specifies if the data label series name is visible. |
show |
Specifies if the data label value is visible. |
text |
Represents the angle to which the text is oriented for data labels. The value should either be an integer from -90 to 90 or the integer 180 for vertically-oriented text. |
vertical |
Represents the vertical alignment of chart data label. See |
Property Details
autoText
Warning
This API is now deprecated.
Specifies if data labels automatically generate appropriate text based on context.
autoText?: boolean;
Property Value
boolean
Remarks
format
Warning
This API is now deprecated.
Specifies the format of chart data labels, which includes fill and font formatting.
format?: Excel.Interfaces.ChartDataLabelFormatData;
Property Value
Remarks
horizontalAlignment
Warning
This API is now deprecated.
Specifies the horizontal alignment for chart data label. See Excel.ChartTextHorizontalAlignment
for details. This property is valid only when the TextOrientation
of data label is 0.
horizontalAlignment?: Excel.ChartTextHorizontalAlignment | "Center" | "Left" | "Right" | "Justify" | "Distributed";
Property Value
Excel.ChartTextHorizontalAlignment | "Center" | "Left" | "Right" | "Justify" | "Distributed"
Remarks
linkNumberFormat
Warning
This API is now deprecated.
Specifies if the number format is linked to the cells. If true
, the number format will change in the labels when it changes in the cells.
linkNumberFormat?: boolean;
Property Value
boolean
Remarks
numberFormat
Warning
This API is now deprecated.
Specifies the format code for data labels.
numberFormat?: string;
Property Value
string
Remarks
position
Warning
This API is now deprecated.
Value that represents the position of the data label. See Excel.ChartDataLabelPosition
for details.
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"
Remarks
separator
Warning
This API is now deprecated.
String representing the separator used for the data labels on a chart.
separator?: string;
Property Value
string
Remarks
showBubbleSize
Warning
This API is now deprecated.
Specifies if the data label bubble size is visible.
showBubbleSize?: boolean;
Property Value
boolean
Remarks
showCategoryName
Warning
This API is now deprecated.
Specifies if the data label category name is visible.
showCategoryName?: boolean;
Property Value
boolean
Remarks
showLegendKey
Warning
This API is now deprecated.
Specifies if the data label legend key is visible.
showLegendKey?: boolean;
Property Value
boolean
Remarks
showPercentage
Warning
This API is now deprecated.
Specifies if the data label percentage is visible.
showPercentage?: boolean;
Property Value
boolean
Remarks
showSeriesName
Warning
This API is now deprecated.
Specifies if the data label series name is visible.
showSeriesName?: boolean;
Property Value
boolean
Remarks
showValue
Warning
This API is now deprecated.
Specifies if the data label value is visible.
showValue?: boolean;
Property Value
boolean
Remarks
textOrientation
Warning
This API is now deprecated.
Represents the angle to which the text is oriented for data labels. The value should either be an integer from -90 to 90 or the integer 180 for vertically-oriented text.
textOrientation?: number;
Property Value
number
Remarks
verticalAlignment
Warning
This API is now deprecated.
Represents the vertical alignment of chart data label. See Excel.ChartTextVerticalAlignment
for details. This property is valid only when TextOrientation
of the data label is -90, 90, or 180.
verticalAlignment?: Excel.ChartTextVerticalAlignment | "Center" | "Bottom" | "Top" | "Justify" | "Distributed";
Property Value
Excel.ChartTextVerticalAlignment | "Center" | "Bottom" | "Top" | "Justify" | "Distributed"
Remarks
Office Add-ins