Excel.Interfaces.ChartTrendlineLabelUpdateData interface

An interface for updating data on the ChartTrendlineLabel object, for use in chartTrendlineLabel.set({ ... }).

Properties

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.

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.

Property Details

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.ChartTrendlineLabelFormatUpdateData;

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

Property Value

string

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?: Excel.ChartTextHorizontalAlignment | "Center" | "Left" | "Right" | "Justify" | "Distributed";

Property Value

Excel.ChartTextHorizontalAlignment | "Center" | "Left" | "Right" | "Justify" | "Distributed"

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

Property Value

number

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

Property Value

string

Remarks

[ API set: ExcelApi 1.8 ]

text

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

text?: string;

Property Value

string

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

Property Value

number

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

Property Value

number

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?: Excel.ChartTextVerticalAlignment | "Center" | "Bottom" | "Top" | "Justify" | "Distributed";

Property Value

Excel.ChartTextVerticalAlignment | "Center" | "Bottom" | "Top" | "Justify" | "Distributed"

Remarks

[ API set: ExcelApi 1.8 ]