Class ExcelChartTrendline
A trendline object
Inherited Members
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 : XmlHelperProperties
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
Return true if the trendline has labels.
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 |