Class ExcelChartTrendline
A trendline object
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 : XmlHelperProperties
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 |
|---|---|
| Boolean |
DisplayRSquaredValue
If to display the R-squared value for a trendline
Declaration
public bool DisplayRSquaredValue { get; set; }Property Value
| Type | Description |
|---|---|
| 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 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 |
|---|---|
| Boolean |
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 |