Skip to end of metadata
Go to start of metadata

Description

A Trendline object represents a series trendline. To create a Trendline object, call Trendlines.CreateTrendline .

C#
vb.net

Properties

Name

Description

BackcastPeriods

For all trendline types except moving average, sets or returns the number of periods the regression should extrapolate backward.

ForecastPeriods

For all trendline types except moving average, sets or returns the number of periods the regression should extrapolate forward.

Intercept

For all trendline types except moving average, sets or returns the point on the value axis where the trendline should intercept.

LegendEntryFont

Sets or returns the Font object for the Trendline's legend entry.

Line

Returns a ChartLine object representing the appearance of the trendline.

Name

Sets or returns the name of the trendline.

RegressionType

Sets or returns the type of regression used to construct this trendline.

RegressionValue

Sets the or returns the value used to generate the regression equation.

ShowEquation

Sets or returns whether the label will contain the equation for the trendline.

ShowLegendEntry

Sets or returns whether an entry for the trendline will be displayed in the chart legend.

ShowRSquaredValue

Sets or returns whether the label will contain the R-squared value for the Trendline's equation.

TrendlineLabel

Returns a ChartText object representing a trendline label.

UseIntercept

Specifies whether the intercept value will be used by the trendline.

Methods

Name

Description

ClearIntercept()

Specifies that the intercept value should not be used.

Nested Classes

Name

Description

Regression

A Trendline.Regression value specifies the type of trendline to display on the graph.
  • No labels