Class ExcelChartTrendline¶

Namespace: OfficeOpenXml.Drawing.Chart
Assembly: EPPlus.dll

A trendline object

public class ExcelChartTrendline : XmlHelper

Inheritance¶

object ← XmlHelper ← ExcelChartTrendline

Inherited Members¶

object.Equals(object?, object?)
object.Equals(object?)
object.GetHashCode()
object.GetType()
object.MemberwiseClone()
object.ReferenceEquals(object?, object?)
object.ToString()

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