Class ExcelChartTrendline

A trendline object

Inheritance

object

XmlHelper

ExcelChartTrendline

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

Namespace: OfficeOpenXml.Drawing.Chart

Assembly: EPPlus.dll

Syntax

public class ExcelChartTrendline : XmlHelper

Properties

Backward

Forcast backwards periods

Declaration

public double Backward { get; set; }

Property Value

Type	Description
double

Border

Access to border properties

Declaration

public ExcelDrawingBorder Border { get; }

Property Value

Type	Description
ExcelDrawingBorder

DisplayEquation

If to display the trendline equation on the chart

Declaration

public bool DisplayEquation { get; set; }

Property Value

Type	Description
bool

DisplayRSquaredValue

If to display the R-squared value for a trendline

Declaration

public bool DisplayRSquaredValue { get; set; }

Property Value

Type	Description
bool

Effect

Effects

Declaration

public ExcelDrawingEffectStyle Effect { get; }

Property Value

Type	Description
ExcelDrawingEffectStyle

Fill

Access to fill properties

Declaration

public ExcelDrawingFill Fill { get; }

Property Value

Type	Description
ExcelDrawingFill

Forward

Forcast forward periods

Declaration

public double Forward { get; set; }

Property Value

Type	Description
double

HasLbl

Return true if the trendline has labels.

Declaration

public bool HasLbl { get; }

Property Value

Type	Description
bool

Intercept

The point where the trendline crosses the vertical axis

Declaration

public double Intercept { get; set; }

Property Value

Type	Description
double

Label

Trendline labels

Declaration

public ExcelChartTrendlineLabel Label { get; }

Property Value

Type	Description
ExcelChartTrendlineLabel

Name

Name in the legend

Declaration

public string Name { get; set; }

Property Value

Type	Description
string

Order

Order for polynominal trendlines

Declaration

public double Order { get; set; }

Property Value

Type	Description
double

Period

Period for monthly average trendlines

Declaration

public double Period { get; set; }

Property Value

Type	Description
double

ThreeD

3D properties

Declaration

public ExcelDrawing3D ThreeD { get; }

Property Value

Type	Description
ExcelDrawing3D

Type

Type of Trendline

Declaration

public eTrendLine Type { get; set; }

Property Value

Type	Description
eTrendLine