Excel.Interfaces.ChartTrendlineLabelLoadOptions interface

This object represents the attributes for a chart trendline label object.

Remarks

[ API set: ExcelApi 1.8 ]

Properties

$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).

autoText

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 null if the chart trendline label is not visible.

horizontalAlignment

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.

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 null if the chart trendline label is not visible.

linkNumberFormat

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).

numberFormat

String value that represents the format code for the trendline label.

text

String representing the text of the trendline label on a chart.

textOrientation

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 null if the chart trendline label is not visible.

verticalAlignment

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.

width

Returns the width, in points, of the chart trendline label. Value is null if the chart trendline label is not visible.

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 the trendline label automatically generates appropriate text based on context.

autoText?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.8 ]

format

The format of the chart trendline label.

format?: Excel.Interfaces.ChartTrendlineLabelFormatLoadOptions;

Property Value

Remarks

[ API set: ExcelApi 1.8 ]

formula

String value that represents the formula of the chart trendline label using A1-style notation.

formula?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.8 ]

height

Returns the height, in points, of the chart trendline label. Value is null if the chart trendline label is not visible.

height?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.8 ]

horizontalAlignment

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?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.8 ]

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 null if the chart trendline label is not visible.

left?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.8 ]

linkNumberFormat

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

[ API set: ExcelApi 1.9 ]

numberFormat

String value that represents the format code for the trendline label.

numberFormat?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.8 ]

text

String representing the text of the trendline label on a chart.

text?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.8 ]

textOrientation

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?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.8 ]

top

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?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.8 ]

verticalAlignment

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?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.8 ]

width

Returns the width, in points, of the chart trendline label. Value is null if the chart trendline label is not visible.

width?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.8 ]