Interface IXLSeriesTrendline

Namespace

SlapKit.Excel.Excel.Charts.SeriesFeatures

Assembly

SlapKit.Excel.dll

public interface IXLSeriesTrendline

Extension Methods

AttributeExtensions.GetMethod<T>(T, Expression<Action<T>>)

AttributeExtensions.GetMethod<T>(T, Expression<Func<T, object>>)

ISupportSeriesTrendlinesExtensions.SetBackward(IXLSeriesTrendline, double)

ISupportSeriesTrendlinesExtensions.SetDisplayEquation(IXLSeriesTrendline, bool)

ISupportSeriesTrendlinesExtensions.SetDisplayRSquaredValue(IXLSeriesTrendline, bool)

ISupportSeriesTrendlinesExtensions.SetForward(IXLSeriesTrendline, double)

ISupportSeriesTrendlinesExtensions.SetIntercept(IXLSeriesTrendline, double?)

ISupportSeriesTrendlinesExtensions.SetLabelStyle(IXLSeriesTrendline, Action<IXLSeriesTrendlineLabel>)

ISupportSeriesTrendlinesExtensions.SetLineStyle(IXLSeriesTrendline, Action<IXLDrawingLineWithArrow>)

ISupportSeriesTrendlinesExtensions.SetName(IXLSeriesTrendline, string?)

ISupportSeriesTrendlinesExtensions.SetPeriod(IXLSeriesTrendline, uint)

ISupportSeriesTrendlinesExtensions.SetPolynomialOrder(IXLSeriesTrendline, byte)

ISupportSeriesTrendlinesExtensions.SetType(IXLSeriesTrendline, XLSeriesTrendlineType)

Properties

Backward

Gets or sets the number of categories (or units on a scatter chart) that the trend line extends before the data for the series that is being trended. On non-scatter charts, the value shall be 0 or 0.5.

double Backward { get; set; }

Property Value

double

DisplayEquation

Gets or sets the equation for the trendline is displayed on the chart (in the same label as the R-squared value).

bool DisplayEquation { get; set; }

Property Value

bool

DisplayRSquaredValue

Gets or sets the R-squared value of the trendline is displayed on the chart (in the same label as the equation).

bool DisplayRSquaredValue { get; set; }

Property Value

bool

Forward

Gets or sets the number of categories (or units on a scatter chart) that the trendline extends after the data for the series that is being trended. On non-scatter charts, the value shall be a multiple of 0.5.

double Forward { get; set; }

Property Value

double

Intercept

Gets or sets the value where the trendline shall cross the y axis. This property shall be supported only when the trendline type is Exponential, Linear, or Polynomial.

double? Intercept { get; set; }

Property Value

double?

LabelStyle

IXLSeriesTrendlineLabel LabelStyle { get; set; }

Property Value

IXLSeriesTrendlineLabel

LineStyle

IXLDrawingLineWithArrow LineStyle { get; set; }

Property Value

IXLDrawingLineWithArrow

Name

string? Name { get; set; }

Property Value

string

Period

Gets or sets the period of the trend line for a moving average trend line. It is ignored for other trend line variants. The minimum value allowed is 2.

uint Period { get; set; }

Property Value

uint

PolynomialOrder

Gets or sets the order of the polynomial trend line. It is ignored for other trend line types. The value can be between 2 and 6.

byte PolynomialOrder { get; set; }

Property Value

byte

Type

XLSeriesTrendlineType Type { get; set; }

Property Value

XLSeriesTrendlineType