Excel.Interfaces.ChartDataLabelsLoadOptions interface
Warning
This API is now deprecated.
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
Warning
This API is now deprecated.
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
Warning
This API is now deprecated.
Specifies if data labels automatically generate appropriate text based on context.
autoText?: boolean;
Property Value
boolean
Remarks
format
Warning
This API is now deprecated.
Specifies the format of chart data labels, which includes fill and font formatting.
format?: Excel.Interfaces.ChartDataLabelFormatLoadOptions;
Property Value
Remarks
horizontalAlignment
Warning
This API is now deprecated.
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
Warning
This API is now deprecated.
Specifies the format code for data labels.
numberFormat?: boolean;
Property Value
boolean
Remarks
position
Warning
This API is now deprecated.
Value that represents the position of the data label. See Excel.ChartDataLabelPosition
for details.
position?: boolean;
Property Value
boolean
Remarks
separator
Warning
This API is now deprecated.
String representing the separator used for the data labels on a chart.
separator?: boolean;
Property Value
boolean
Remarks
showBubbleSize
Warning
This API is now deprecated.
Specifies if the data label bubble size is visible.
showBubbleSize?: boolean;
Property Value
boolean
Remarks
showCategoryName
Warning
This API is now deprecated.
Specifies if the data label category name is visible.
showCategoryName?: boolean;
Property Value
boolean
Remarks
showLegendKey
Warning
This API is now deprecated.
Specifies if the data label legend key is visible.
showLegendKey?: boolean;
Property Value
boolean
Remarks
showPercentage
Warning
This API is now deprecated.
Specifies if the data label percentage is visible.
showPercentage?: boolean;
Property Value
boolean
Remarks
showSeriesName
Warning
This API is now deprecated.
Specifies if the data label series name is visible.
showSeriesName?: boolean;
Property Value
boolean
Remarks
showValue
Warning
This API is now deprecated.
Specifies if the data label value is visible.
showValue?: boolean;
Property Value
boolean
Remarks
textOrientation
Warning
This API is now deprecated.
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
Warning
This API is now deprecated.
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
Office Add-ins