GrapeCity.Documents.Excel.Drawing.ITrendline

Interface ITrendline

Namespace

GrapeCity.Documents.Excel.Drawing

Assembly

GcDocs.Excel.dll

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

public interface ITrendline

Properties

Backward

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

double Backward { get; set; }

Property Value

double

DataLabel

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

IDataLabel DataLabel { get; }

Property Value

IDataLabel

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.

bool DisplayEquation { get; set; }

Property Value

bool

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.

bool DisplayRSquared { get; set; }

Property Value

bool

Format

Returns the format for chart elements.

IChartFormat Format { get; }

Property Value

IChartFormat

Forward

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

double Forward { get; set; }

Property Value

double

Index

Returns the index number of the object within the collection of similar objects.

int Index { get; }

Property Value

int

Intercept

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

double Intercept { get; set; }

Property Value

double

Name

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

string Name { get; set; }

Property Value

string

NameIsAuto

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

bool NameIsAuto { get; set; }

Property Value

bool

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.

int Order { get; set; }

Property Value

int

Parent

Returns the parent object for the specified object.

ISeries Parent { get; }

Property Value

ISeries

Period

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

int Period { get; set; }

Property Value

int

Type

Gets or sets the trendline type.

TrendlineType Type { get; set; }

Property Value

TrendlineType

Methods

ClearFormats()

Clears the formatting of the object.

void ClearFormats()

Delete()

Deletes the object.

void Delete()