Class ExcelChartTrendline

Namespace

OfficeOpenXml.Drawing.Chart

Assembly

EPPlus.dll

A trendline object

public class ExcelChartTrendline : XmlHelper

Inheritance

object

XmlHelper

ExcelChartTrendline

Inherited Members

object.GetType()

object.MemberwiseClone()

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

Properties

Backward

Forcast backwards periods

public decimal Backward { get; set; }

Property Value

decimal

Border

Access to border properties

public ExcelDrawingBorder Border { get; }

Property Value

ExcelDrawingBorder

DisplayEquation

If to display the trendline equation on the chart

public bool DisplayEquation { get; set; }

Property Value

bool

DisplayRSquaredValue

If to display the R-squared value for a trendline

public bool DisplayRSquaredValue { get; set; }

Property Value

bool

Effect

Effects

public ExcelDrawingEffectStyle Effect { get; }

Property Value

ExcelDrawingEffectStyle

Fill

Access to fill properties

public ExcelDrawingFill Fill { get; }

Property Value

ExcelDrawingFill

Forward

Forcast forward periods

public decimal Forward { get; set; }

Property Value

decimal

HasLbl

Return true if the trendline has labels.

public bool HasLbl { get; }

Property Value

bool

Intercept

The point where the trendline crosses the vertical axis

public decimal Intercept { get; set; }

Property Value

decimal

Label

Trendline labels

public ExcelChartTrendlineLabel Label { get; }

Property Value

ExcelChartTrendlineLabel

Name

Name in the legend

public string Name { get; set; }

Property Value

string

Order

Order for polynominal trendlines

public decimal Order { get; set; }

Property Value

decimal

Period

Period for monthly average trendlines

public decimal Period { get; set; }

Property Value

decimal

ThreeD

3D properties

public ExcelDrawing3D ThreeD { get; }

Property Value

ExcelDrawing3D

Type

Type of Trendline

public eTrendLine Type { get; set; }

Property Value

eTrendLine