Trendline Members 

Represents a trendline in a chart. A trendline shows the trend, or direction, of data in a series.

The following tables list the members exposed by the Trendline type.

Public Properties

	Name	Description
	Application	Returns an Application object that represents the Microsoft Excel application.
	Backward	Returns or sets the number of periods (or units on a scatter chart) that the trendline extends backward.
	Border	Returns a Border object that represents the border of the object.
	Creator	Returns a 32-bit integer that indicates the application in which this object was created.
	DataLabel	Returns a DataLabel object that represents the data label associated with the point or trendline.
	DisplayEquation	True if the equation for the trendline is displayed on the chart (in the same data label as the R-squared value). Setting this property to True automatically turns on data labels.
	DisplayRSquared	True if the R-squared value of the trendline is displayed on the chart (in the same data label as the equation). Setting this property to True automatically turns on data labels.
	Forward	Returns or sets the number of periods (or units on a scatter chart) that the trendline extends forward.
	Index	Returns the index number of the object within the collection of similar objects.
	Intercept	Returns or sets the point where the trendline crosses the value axis.
	InterceptIsAuto	True if the point where the trendline crosses the value axis is automatically determined by the regression.
	Name	Returns or sets the name of the object.
	NameIsAuto	True if Microsoft Excel automatically determines the name of the trendline.
	Order	Returns or sets the trendline order (an integer greater than 1) when the trendline type is xlPolynomial.
	Parent	Returns the parent object for the specified object.
	Period	Returns or sets the period for the moving-average trendline.
	Type	Returns or sets the trendline type.

Top

Public Methods

	Name	Description
	ClearFormats	Clears the formatting of the object.
	Delete	Deletes the object.
	Select	Selects the object.

Top

See Also

Reference

Trendline Interface
Microsoft.Office.Interop.Excel Namespace