Excel.Interfaces.ChartDataLabelsLoadOptions interface
Represents a collection of all the data labels on a chart point.
Remarks
[Api set: ExcelApi 1.1]
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 |
Specifies 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 |
Specifies if 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 |
Specifies if 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
[Api set: ExcelApi 1.8]
format
Specifies the format of chart data labels, which includes fill and font formatting.
format?: Excel.Interfaces.ChartDataLabelFormatLoadOptions;Property Value
Remarks
[Api set: ExcelApi 1.1]
geometricShapeType
Specifies 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
[Api set: ExcelApi 1.19]
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
[Api set: ExcelApi 1.8]
leaderLines
Gets an object that represents the leader lines of the data labels.
leaderLines?: Excel.Interfaces.ChartLeaderLinesLoadOptions;Property Value
Remarks
[Api set: ExcelApi 1.19]
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
[Api set: ExcelApi 1.9]
numberFormat
Specifies the format code for data labels.
numberFormat?: boolean;Property Value
boolean
Remarks
[Api set: ExcelApi 1.8]
position
Value that represents the position of the data label. See Excel.ChartDataLabelPosition for details.
position?: boolean;Property Value
boolean
Remarks
[Api set: ExcelApi 1.1]
separator
String representing the separator used for the data labels on a chart.
separator?: boolean;Property Value
boolean
Remarks
[Api set: ExcelApi 1.1]
showAsStickyCallout
Specifies if 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
[Api set: ExcelApi 1.19]
showBubbleSize
Specifies if the data label bubble size is visible.
showBubbleSize?: boolean;Property Value
boolean
Remarks
[Api set: ExcelApi 1.1]
showCategoryName
Specifies if the data label category name is visible.
showCategoryName?: boolean;Property Value
boolean
Remarks
[Api set: ExcelApi 1.1]
showLeaderLines
Specifies if leader lines are displayed for the data labels. true if leader lines are shown; otherwise, false.
showLeaderLines?: boolean;Property Value
boolean
Remarks
[Api set: ExcelApi 1.19]
showLegendKey
Specifies if the data label legend key is visible.
showLegendKey?: boolean;Property Value
boolean
Remarks
[Api set: ExcelApi 1.1]
showPercentage
Specifies if the data label percentage is visible.
showPercentage?: boolean;Property Value
boolean
Remarks
[Api set: ExcelApi 1.1]
showSeriesName
Specifies if the data label series name is visible.
showSeriesName?: boolean;Property Value
boolean
Remarks
[Api set: ExcelApi 1.1]
showValue
Specifies if the data label value is visible.
showValue?: boolean;Property Value
boolean
Remarks
[Api set: ExcelApi 1.1]
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
[Api set: ExcelApi 1.8]
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
Remarks
[Api set: ExcelApi 1.8]