Excel.Interfaces.ChartDataLabelsLoadOptions interface
Represents a collection of all the data labels on a chart point.
Remarks
Properties
| $all | Specifying |
| 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
$all
Specifying $all for the load options loads all the scalar properties (such as Range.address) but not the navigational properties (such as Range.format.fill.color).
$all?: boolean;Property Value
boolean
autoText
Specifies if data labels automatically generate appropriate text based on context.
autoText?: boolean;Property Value
boolean
Remarks
format
Specifies the format of chart data labels, which includes fill and font formatting.
format?: Excel.Interfaces.ChartDataLabelFormatLoadOptions;Property Value
Remarks
horizontalAlignment
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?: boolean;Property Value
boolean
Remarks
linkNumberFormat
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
Specifies the format code for data labels.
numberFormat?: boolean;Property Value
boolean
Remarks
position
Value that represents the position of the data label. See Excel.ChartDataLabelPosition for details.
position?: boolean;Property Value
boolean
Remarks
separator
String representing the separator used for the data labels on a chart.
separator?: boolean;Property Value
boolean
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
textOrientation
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?: boolean;Property Value
boolean
Remarks
verticalAlignment
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?: boolean;Property Value
boolean