[]
        
(Showing Draft Content)

GrapeCity.Documents.Excel.Drawing.ITrendline

ITrendline Interface

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

Namespace: GrapeCity.Documents.Excel.Drawing
Assembly: DS.Documents.Excel.dll
Syntax
public interface ITrendline
Public Interface ITrendline

Properties

Name Description
Backward

Gets or sets the number of periods (or units on a scatter chart) that the trendline extends backward.

DataLabel

Returns a IDataLabel object that represents the data label associated with the trendline.

DisplayEquation

Gets or sets whether to display the equation for the trendline (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

Gets or sets whether to display the R-squared value (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.

Forward

Gets 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

Gets or sets the point where the trendline crosses the value axis.

Name

Returns or sets a String value representing the name of the object.

NameIsAuto

Get or set if the trendline's name is automatically determined.

Order

Gets or sets the trendline order (an integer is greater than or equal to 2 and less than or equal to 6) when the trendline type is Polynomial.

Parent

Returns the parent object for the specified object.

Period

Gets or sets the period for the moving-average trendline.

Type

Gets or sets the trendline type.

Methods

Name Description
ClearFormats()

Clears the formatting of the object.

Delete()

Deletes the object.