Excel.Interfaces.ChartTrendlineLabelUpdateData interface
Warning
This API is now deprecated.
An interface for updating data on the ChartTrendlineLabel
object, for use in chartTrendlineLabel.set({ ... })
.
Properties
auto |
Specifies if the trendline label automatically generates appropriate text based on context. |
format | The format of the chart trendline label. |
formula | String value that represents the formula of the chart trendline label using A1-style notation. |
horizontal |
Represents the horizontal alignment of the chart trendline label. See |
left | Represents the distance, in points, from the left edge of the chart trendline label to the left edge of the chart area. Value is |
link |
Specifies if the number format is linked to the cells (so that the number format changes in the labels when it changes in the cells). |
number |
String value that represents the format code for the trendline label. |
text | String representing the text of the trendline label on a chart. |
text |
Represents the angle to which the text is oriented for the chart trendline label. The value should either be an integer from -90 to 90 or the integer 180 for vertically-oriented text. |
top | Represents the distance, in points, from the top edge of the chart trendline label to the top of the chart area. Value is |
vertical |
Represents the vertical alignment of the chart trendline label. See |
Property Details
autoText
Warning
This API is now deprecated.
Specifies if the trendline label automatically generates appropriate text based on context.
autoText?: boolean;
Property Value
boolean
Remarks
format
Warning
This API is now deprecated.
The format of the chart trendline label.
format?: Excel.Interfaces.ChartTrendlineLabelFormatUpdateData;
Property Value
Remarks
formula
Warning
This API is now deprecated.
String value that represents the formula of the chart trendline label using A1-style notation.
formula?: string;
Property Value
string
Remarks
horizontalAlignment
Warning
This API is now deprecated.
Represents the horizontal alignment of the chart trendline label. See Excel.ChartTextHorizontalAlignment
for details. This property is valid only when TextOrientation
of a trendline label is -90, 90, or 180.
horizontalAlignment?: Excel.ChartTextHorizontalAlignment | "Center" | "Left" | "Right" | "Justify" | "Distributed";
Property Value
Excel.ChartTextHorizontalAlignment | "Center" | "Left" | "Right" | "Justify" | "Distributed"
Remarks
left
Warning
This API is now deprecated.
Represents the distance, in points, from the left edge of the chart trendline label to the left edge of the chart area. Value is null
if the chart trendline label is not visible.
left?: number;
Property Value
number
Remarks
linkNumberFormat
Warning
This API is now deprecated.
Specifies if the number format is linked to the cells (so that the number format changes in the labels when it changes in the cells).
linkNumberFormat?: boolean;
Property Value
boolean
Remarks
numberFormat
Warning
This API is now deprecated.
String value that represents the format code for the trendline label.
numberFormat?: string;
Property Value
string
Remarks
text
Warning
This API is now deprecated.
String representing the text of the trendline label on a chart.
text?: string;
Property Value
string
Remarks
textOrientation
Warning
This API is now deprecated.
Represents the angle to which the text is oriented for the chart trendline label. The value should either be an integer from -90 to 90 or the integer 180 for vertically-oriented text.
textOrientation?: number;
Property Value
number
Remarks
top
Warning
This API is now deprecated.
Represents the distance, in points, from the top edge of the chart trendline label to the top of the chart area. Value is null
if the chart trendline label is not visible.
top?: number;
Property Value
number
Remarks
verticalAlignment
Warning
This API is now deprecated.
Represents the vertical alignment of the chart trendline label. See Excel.ChartTextVerticalAlignment
for details. This property is valid only when TextOrientation
of a trendline label is 0.
verticalAlignment?: Excel.ChartTextVerticalAlignment | "Center" | "Bottom" | "Top" | "Justify" | "Distributed";
Property Value
Excel.ChartTextVerticalAlignment | "Center" | "Bottom" | "Top" | "Justify" | "Distributed"
Remarks
Office Add-ins