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 |
| 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
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