Excel.Interfaces.ChartDataLabelData interface
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
Specifies if the data label automatically generates appropriate text based on context.
autoText?: boolean;Property Value
boolean
Remarks
format
Represents the format of chart data label.
format?: Excel.Interfaces.ChartDataLabelFormatData;Property Value
Remarks
formula
String value that represents the formula of chart data label using A1-style notation.
formula?: string;Property Value
string
Remarks
height
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
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
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
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
String value that represents the format code for data label.
numberFormat?: string;Property Value
string
Remarks
position
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
String representing the separator used for the data label on a chart.
separator?: string;Property Value
string
Remarks
showBubbleSize
Specifies if the data label bubble size is visible.
showBubbleSize?: boolean;Property Value
boolean
Remarks
showCategoryName
Specifies if the data label category name is visible.
showCategoryName?: boolean;Property Value
boolean
Remarks
showLegendKey
Specifies if the data label legend key is visible.
showLegendKey?: boolean;Property Value
boolean
Remarks
showPercentage
Specifies if the data label percentage is visible.
showPercentage?: boolean;Property Value
boolean
Remarks
showSeriesName
Specifies if the data label series name is visible.
showSeriesName?: boolean;Property Value
boolean
Remarks
showValue
Specifies if the data label value is visible.
showValue?: boolean;Property Value
boolean
Remarks
text
String representing the text of the data label on a chart.
text?: string;Property Value
string
Remarks
textOrientation
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
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
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
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
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for