Class ExcelChartTrendline

A trendline object

Inheritance

System.Object

XmlHelper

ExcelChartTrendline

Inherited Members

XmlHelper.AddSchemaNodeOrder(String[], String[])

XmlHelper.AddSchemaNodeOrder(String[], String[], Int32[])

XmlHelper.GetBoolFromString(String)

XmlHelper.CreatespPrNode(String, Boolean)

System.Object.Equals(System.Object)

System.Object.Equals(System.Object, System.Object)

System.Object.GetHashCode()

System.Object.GetType()

System.Object.MemberwiseClone()

System.Object.ReferenceEquals(System.Object, System.Object)

System.Object.ToString()

Namespace: OfficeOpenXml.Drawing.Chart

Assembly: EPPlus.dll

Syntax

public class ExcelChartTrendline : XmlHelper, IDrawingStyleBase

Properties

Backward

Forcast backwards periods

Declaration

public decimal Backward { get; set; }

Property Value

Type	Description
System.Decimal

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
System.Boolean

DisplayRSquaredValue

If to display the R-squared value for a trendline

Declaration

public bool DisplayRSquaredValue { get; set; }

Property Value

Type	Description
System.Boolean

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 decimal Forward { get; set; }

Property Value

Type	Description
System.Decimal

HasLbl

Declaration

public bool HasLbl { get; }

Property Value

Type	Description
System.Boolean

Intercept

The point where the trendline crosses the vertical axis

Declaration

public decimal Intercept { get; set; }

Property Value

Type	Description
System.Decimal

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
System.String

Order

Order for polynominal trendlines

Declaration

public decimal Order { get; set; }

Property Value

Type	Description
System.Decimal

Period

Period for monthly average trendlines

Declaration

public decimal Period { get; set; }

Property Value

Type	Description
System.Decimal

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