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
Remarks
Office Add-ins