Excel.Interfaces.ChartDataLabelData interface
Warning
This API is now deprecated.
An interface describing the data returned by calling chartDataLabel.toJSON()
.
Properties
auto |
Specifies if the data label automatically generates appropriate text based on context. |
format | Represents the format of chart data label. |
formula | String value that represents the formula of chart data label using A1-style notation. |
height | Returns the height, in points, of the chart data label. Value is |
horizontal |
Represents the horizontal alignment for chart data label. See |
left | Represents the distance, in points, from the left edge of chart data label to the left edge of chart area. Value is |
link |
Specifies if the number format is linked to the cells (so that the number format changes in the labels when it changes in the cells). |
number |
String value that represents the format code for data label. |
position | Value that represents the position of the data label. See |
separator | String representing the separator used for the data label 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 | String representing the text of the data label on a chart. |
text |
Represents the angle to which the text is oriented for the chart data label. The value should either be an integer from -90 to 90 or the integer 180 for vertically-oriented text. |
top | Represents the distance, in points, from the top edge of chart data label to the top of chart area. Value is |
vertical |
Represents the vertical alignment of chart data label. See |
width | Returns the width, in points, of the chart data label. Value is |
Property Details
autoText
Warning
This API is now deprecated.
Specifies if the data label automatically generates appropriate text based on context.
autoText?: boolean;
Property Value
boolean
Remarks
format
Warning
This API is now deprecated.
Represents the format of chart data label.
format?: Excel.Interfaces.ChartDataLabelFormatData;
Property Value
Remarks
formula
Warning
This API is now deprecated.
String value that represents the formula of chart data label using A1-style notation.
formula?: string;
Property Value
string
Remarks
height
Warning
This API is now deprecated.
Returns the height, in points, of the chart data label. Value is null
if the chart data label is not visible.
height?: number;
Property Value
number
Remarks
horizontalAlignment
Warning
This API is now deprecated.
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.
horizontalAlignment?: Excel.ChartTextHorizontalAlignment | "Center" | "Left" | "Right" | "Justify" | "Distributed";
Property Value
Excel.ChartTextHorizontalAlignment | "Center" | "Left" | "Right" | "Justify" | "Distributed"
Remarks
left
Warning
This API is now deprecated.
Represents the distance, in points, from the left edge of chart data label to the left edge of chart area. Value is null
if the chart data label is not visible.
left?: number;
Property Value
number
Remarks
linkNumberFormat
Warning
This API is now deprecated.
Specifies if the number format is linked to the cells (so that the number format changes in the labels when it changes in the cells).
linkNumberFormat?: boolean;
Property Value
boolean
Remarks
numberFormat
Warning
This API is now deprecated.
String value that represents the format code for data label.
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 label 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
text
Warning
This API is now deprecated.
String representing the text of the data label on a chart.
text?: string;
Property Value
string
Remarks
textOrientation
Warning
This API is now deprecated.
Represents the angle to which the text is oriented for the chart data label. 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
top
Warning
This API is now deprecated.
Represents the distance, in points, from the top edge of chart data label to the top of chart area. Value is null
if the chart data label is not visible.
top?: 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 data label is 0.
verticalAlignment?: Excel.ChartTextVerticalAlignment | "Center" | "Bottom" | "Top" | "Justify" | "Distributed";
Property Value
Excel.ChartTextVerticalAlignment | "Center" | "Bottom" | "Top" | "Justify" | "Distributed"
Remarks
width
Warning
This API is now deprecated.
Returns the width, in points, of the chart data label. Value is null
if the chart data label is not visible.
width?: number;
Property Value
number
Remarks
Office Add-ins