Trendline Members

Include Protected Members
Include Inherited Members

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

The Trendline type exposes the following members.

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.
	Backward2	Returns or sets the number of periods (or units on a scatter chart) that the trendline extends backward. Read/write.
	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.
	Format	Returns the format for chart elements. Read-only.
	Forward	Returns or sets the number of periods (or units on a scatter chart) that the trendline extends forward.
	Forward2	Returns or sets the number of periods (or units on a scatter chart) that the trendline extends forward. Read/write.
	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

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