The TrendLine Collection Editor is used for adding or modifying TrendLines that approximate the data which the functions trend at design time. For more information on TrendLines see, Working with TrendLines.
Properties available in the TrendLine Collection Editor
The following properties are available for the user in the TrendLine Collection Editor at design time or they can be used in the TrendLine class at run time:
Misc Properties of the TrendLine Collection Editor:
Members | Description |
---|---|
DataArray | Gets or sets the array of y values that is used for the trendline. |
LegendEntry | Gets or sets whether the trendline appears in the legend. |
Period | Gets or sets period for Moving Average trendline. |
RegressionOptions | Gets the options for regression calculation. |
NumTerms | Gets or sets the number of terms in regression equation. Only for polynomial and fourier trend lines. |
UseYIntercept | Gets or sets whether the trend line uses Yintercept property. Only for polynomial trend line. |
YIntercept | Gets or sets the y value at which trend line intercepts x =0 line. Only for polynomial trend line. |
Coeffs | Gets the coefficients of regression equation. |
DF | Gets the degrees of freedom. |
F | Gets the F-observed(F-statistic) value. |
Rsq | Gets the coefficient of determination(R-squared). |
Sey | Gets the standard error for the y estimate. |
Sse | Gets the sum of squares due to error. |
Ssr | Gets the sum of squares due to regression. |
SeriesIndex | Gets or sets the data series index that is used for trendline plotting. |
SeriesLabel | Gets the data series label that is used for trendline plotting. |
Text | Gets or sets the text that will be shown in legend. |
TrendLineType | Gets or sets the type of trendline. |
Plot Properties of the TrendLine Collection Editor:
Members | Description |
---|---|
ForecastBackward | Gets or sets how long the trendline extends comparing series data minimum. |
ForecastForward | Gets or sets how long the trendline extends comparing series data maximum. |
LineStyle | Gets or sets the line used to plot the TrendLine. |
Color | Gets or sets the color of the line. |
Pattern | Gets or sets the pattern of the line. |
Thickness | Gets or sets the thickness of the line. |
PlotLinesMethod | Gets or sets the method of trendline plotting. |
PlotNumPoints | Gets or sets the number of points of trendline plotting. |
PlotOverData | Gets or sets whether the trendline is plotted over or behind data. |
Visible | Gets or sets whether the trendline is visible. |