Excel.Interfaces.ChartTrendlineLoadOptions interface

Package:

excel

This object represents the attributes for a chart trendline object.

Remarks

[ API set: ExcelApi 1.7 ]

Properties

$all	Specifying $all for the LoadOptions loads all the scalar properties (e.g.: Range.address) but not the navigational properties (e.g.: Range.format.fill.color).
format	Represents the formatting of a chart trendline.
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.
movingAveragePeriod	Represents the period of a chart trendline. Only applicable to trendlines with the type MovingAverage.
name	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	Represents the order of a chart trendline. Only applicable to trendlines with the type Polynomial.
type	Represents the type of a chart trendline.

Property Details

$all

Specifying $all for the LoadOptions loads all the scalar properties (e.g.: Range.address) but not the navigational properties (e.g.: Range.format.fill.color).

$all?: boolean;

Property Value

boolean

format

Represents the formatting of a chart trendline.

format?: Excel.Interfaces.ChartTrendlineFormatLoadOptions;

Property Value

Excel.Interfaces.ChartTrendlineFormatLoadOptions

Remarks

[ API set: ExcelApi 1.7 ]

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.

intercept?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.7 ]

movingAveragePeriod

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

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

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 ]

type

Represents the type of a chart trendline.

type?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.7 ]