Excel.Interfaces.ChartTrendlineCollectionLoadOptions interface

Represents a collection of chart trendlines.

Remarks

[ API set: ExcelApi 1.7 ]

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

backwardPeriod

For EACH ITEM in the collection: Represents the number of periods that the trendline extends backward.

format

For EACH ITEM in the collection: Represents the formatting of a chart trendline.

forwardPeriod

For EACH ITEM in the collection: Represents the number of periods that the trendline extends forward.

intercept

For EACH ITEM in the collection: Represents the intercept value of the trendline. Can be set to a numeric value or an empty string (for automatic values). The returned value is always a number.

label

For EACH ITEM in the collection: Represents the label of a chart trendline.

movingAveragePeriod

For EACH ITEM in the collection: Represents the period of a chart trendline. Only applicable to trendlines with the type MovingAverage.

name

For EACH ITEM in the collection: Represents the name of the trendline. Can be set to a string value, a null value represents automatic values. The returned value is always a string

polynomialOrder

For EACH ITEM in the collection: Represents the order of a chart trendline. Only applicable to trendlines with the type Polynomial.

showEquation

For EACH ITEM in the collection: True if the equation for the trendline is displayed on the chart.

showRSquared

For EACH ITEM in the collection: True if the r-squared value for the trendline is displayed on the chart.

type

For EACH ITEM in the collection: Represents the type of a chart trendline.

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

backwardPeriod

For EACH ITEM in the collection: Represents the number of periods that the trendline extends backward.

backwardPeriod?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.8 ]

format

For EACH ITEM in the collection: Represents the formatting of a chart trendline.

format?: Excel.Interfaces.ChartTrendlineFormatLoadOptions;

Property Value

Remarks

[ API set: ExcelApi 1.7 ]

forwardPeriod

For EACH ITEM in the collection: Represents the number of periods that the trendline extends forward.

forwardPeriod?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.8 ]

intercept

For EACH ITEM in the collection: Represents the intercept value of the trendline. Can be set to a numeric value or an empty string (for automatic values). The returned value is always a number.

intercept?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.7 ]

label

For EACH ITEM in the collection: Represents the label of a chart trendline.

label?: Excel.Interfaces.ChartTrendlineLabelLoadOptions;

Property Value

Remarks

[ API set: ExcelApi 1.8 ]

movingAveragePeriod

For EACH ITEM in the collection: Represents the period of a chart trendline. Only applicable to trendlines with the type MovingAverage.

movingAveragePeriod?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.7 ]

name

For EACH ITEM in the collection: Represents the name of the trendline. Can be set to a string value, a null value represents automatic values. The returned value is always a string

name?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.7 ]

polynomialOrder

For EACH ITEM in the collection: Represents the order of a chart trendline. Only applicable to trendlines with the type Polynomial.

polynomialOrder?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.7 ]

showEquation

For EACH ITEM in the collection: True if the equation for the trendline is displayed on the chart.

showEquation?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.8 ]

showRSquared

For EACH ITEM in the collection: True if the r-squared value for the trendline is displayed on the chart.

showRSquared?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.8 ]

type

For EACH ITEM in the collection: Represents the type of a chart trendline.

type?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.7 ]