Excel.Interfaces.ChartTrendlineLoadOptions interface
This object represents the attributes for a chart trendline object.
Remarks
Properties
| $all | Specifying |
| 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. |
| moving |
Represents the period of a chart trendline. Only applicable to trendlines with the type |
| name | Represents the name of the trendline. Can be set to a string value, a |
| polynomial |
Represents the order of a chart trendline. Only applicable to trendlines with the type |
| type | 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
format
Represents the formatting of a chart trendline.
format?: Excel.Interfaces.ChartTrendlineFormatLoadOptions;Property Value
Remarks
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
movingAveragePeriod
Represents the period of a chart trendline. Only applicable to trendlines with the type MovingAverage.
movingAveragePeriod?: boolean;Property Value
boolean
Remarks
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
polynomialOrder
Represents the order of a chart trendline. Only applicable to trendlines with the type Polynomial.
polynomialOrder?: boolean;Property Value
boolean
Remarks
type
Represents the type of a chart trendline.
type?: boolean;Property Value
boolean