Excel.Interfaces.ChartTrendlineLoadOptions interface

This object represents the attributes for a chart trendline object.

[ API set: ExcelApi 1.7 ]

Properties

$all
backwardPeriod

Represents the number of periods that the trendline extends backward.

[ API set: ExcelApi 1.8 ]

format

Represents the formatting of a chart trendline.

[ API set: ExcelApi 1.7 ]

forwardPeriod

Represents the number of periods that the trendline extends forward.

[ API set: ExcelApi 1.8 ]

intercept

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.

[ API set: ExcelApi 1.7 ]

label

Represents the label of a chart trendline.

[ API set: ExcelApi 1.8 ]

movingAveragePeriod

Represents the period of a chart trendline. Only applicable for trendline with MovingAverage type.

[ API set: ExcelApi 1.7 ]

name

Represents the name of the trendline. Can be set to a string value, or can be set to null value represents automatic values. The returned value is always a string

[ API set: ExcelApi 1.7 ]

polynomialOrder

Represents the order of a chart trendline. Only applicable for trendline with Polynomial type.

[ API set: ExcelApi 1.7 ]

showEquation

True if the equation for the trendline is displayed on the chart.

[ API set: ExcelApi 1.8 ]

showRSquared

True if the R-squared for the trendline is displayed on the chart.

[ API set: ExcelApi 1.8 ]

type

Represents the type of a chart trendline.

[ API set: ExcelApi 1.7 ]

Property Details

$all

$all?: boolean;

Property Value

boolean

backwardPeriod

Represents the number of periods that the trendline extends backward.

[ API set: ExcelApi 1.8 ]

backwardPeriod?: boolean;

Property Value

boolean

format

Represents the formatting of a chart trendline.

[ API set: ExcelApi 1.7 ]

format?: Excel.Interfaces.ChartTrendlineFormatLoadOptions;

Property Value

forwardPeriod

Represents the number of periods that the trendline extends forward.

[ API set: ExcelApi 1.8 ]

forwardPeriod?: boolean;

Property Value

boolean

intercept

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.

[ API set: ExcelApi 1.7 ]

intercept?: boolean;

Property Value

boolean

label

Represents the label of a chart trendline.

[ API set: ExcelApi 1.8 ]

label?: Excel.Interfaces.ChartTrendlineLabelLoadOptions;

Property Value

movingAveragePeriod

Represents the period of a chart trendline. Only applicable for trendline with MovingAverage type.

[ API set: ExcelApi 1.7 ]

movingAveragePeriod?: boolean;

Property Value

boolean

name

Represents the name of the trendline. Can be set to a string value, or can be set to null value represents automatic values. The returned value is always a string

[ API set: ExcelApi 1.7 ]

name?: boolean;

Property Value

boolean

polynomialOrder

Represents the order of a chart trendline. Only applicable for trendline with Polynomial type.

[ API set: ExcelApi 1.7 ]

polynomialOrder?: boolean;

Property Value

boolean

showEquation

True if the equation for the trendline is displayed on the chart.

[ API set: ExcelApi 1.8 ]

showEquation?: boolean;

Property Value

boolean

showRSquared

True if the R-squared for the trendline is displayed on the chart.

[ API set: ExcelApi 1.8 ]

showRSquared?: boolean;

Property Value

boolean

type

Represents the type of a chart trendline.

[ API set: ExcelApi 1.7 ]

type?: boolean;

Property Value

boolean