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. |
| geometric |
Gets or sets the geometric shape type of the data labels. See |
| horizontal |
Specifies the horizontal alignment for chart data label. See |
| leader |
Gets an object that represents the leader lines of the data labels. |
| 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 |
Gets a value that indicates whether the data labels are shown as a callout with the tail anchor attached to the data point. If |
| show |
Specifies if the data label bubble size is visible. |
| show |
Specifies if the data label category name is visible. |
| show |
Gets or sets a value that indicates whether leader lines are displayed for the data labels. |
| 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
geometricShapeType
Note
This API is provided as a preview for developers and may change based on feedback that we receive. Do not use this API in a production environment.
Gets or sets the geometric shape type of the data labels. See Excel.GeometricShapeType for more details. Value is null if the data labels are not geometric shapes.
geometricShapeType?: boolean;Property Value
boolean
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
leaderLines
Note
This API is provided as a preview for developers and may change based on feedback that we receive. Do not use this API in a production environment.
Gets an object that represents the leader lines of the data labels.
leaderLines?: Excel.Interfaces.ChartLeaderLinesLoadOptions;Property Value
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
showAsStickyCallout
Note
This API is provided as a preview for developers and may change based on feedback that we receive. Do not use this API in a production environment.
Gets a value that indicates whether the data labels are shown as a callout with the tail anchor attached to the data point. If true, the callout is one of the following values: "AccentCallout1", "AccentCallout2", "BorderCallout1", "BorderCallout2", "WedgeRectCallout", "WedgeRRectCallout" or "WedgeEllipseCallout". See GeometricShapeType for more details.
showAsStickyCallout?: 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
showLeaderLines
Note
This API is provided as a preview for developers and may change based on feedback that we receive. Do not use this API in a production environment.
Gets or sets a value that indicates whether leader lines are displayed for the data labels. true if leader lines are shown; otherwise, false.
showLeaderLines?: 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