Excel.Interfaces.ChartTrendlineLabelData interface
An interface describing the data returned by calling chartTrendlineLabel.toJSON()
.
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. |
height | Returns the height, in points, of the chart trendline label. Value is |
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 |
width | Returns the width, in points, of the chart trendline label. Value is |
Specifies if the trendline label automatically generates appropriate text based on context.
autoText?: boolean;
Property Value
boolean
Remarks
The format of the chart trendline label.
format?: Excel.Interfaces.ChartTrendlineLabelFormatData;
Property Value
Remarks
String value that represents the formula of the chart trendline label using A1-style notation.
formula?: string;
Property Value
string
Remarks
Returns the height, in points, of the chart trendline label. Value is null
if the chart trendline label is not visible.
height?: number;
Property Value
number
Remarks
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
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
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
String value that represents the format code for the trendline label.
numberFormat?: string;
Property Value
string
Remarks
String representing the text of the trendline label on a chart.
text?: string;
Property Value
string
Remarks
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
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
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
Returns the width, in points, of the chart trendline label. Value is null
if the chart trendline label is not visible.
width?: number;
Property Value
number
Remarks
Office Add-ins feedback
Office Add-ins is an open source project. Select a link to provide feedback: