Polynomial Trendline
In This Topic
A Polynomial trendline creates a curved line, illustrating fluctuations in the data values. The trendline uses the following equation:
y=b+c1x+c2x2+c3x3+
where c1, c2, c3 are constants.
| Property | Description |
|---|---|
| BackwardForecastPeriod | Sets a number of periods that the forecast extends backward. |
| DetailLevel | Specifies if the overlay calculation should include the entire data set or each detail group. Select from Total or Group. |
| FieldName | Sets the field name for the reference line to use. |
| ForwardForecastPeriod | Sets a number of periods that the forecast extends forward. |
| Intercept | Sets the intercept value of Y-axis. |
| LegendLabel | Sets the legend label of the trendline. |
| Order | Sets a number of terms in the Polynomial equation. The default value is 2, the value less than 2 is treated as 2, values greater than 6 are treated as 6. |
|
Display |
Sets the display position. Select from Front or Back. |
|
Name |
Enter the name of the trendline. |
| Type |
Select the type of the trendline from the list of available types. |
| LineStyle | Sets the style of the line. Select the LineColor, LineStyle and LineWidth properties of the line. |
In the OverlayDesigner Collection Editor, you can set a Polynomial trendline with the properties as follows.
| Property | Value |
| LineStyle > LineColor | Red |
| LineStyle > LineStyle | Solid |
| LineStyle > LineWidth | 3pt |
| Configurations > BackwardForecastPeriod | 0 |
| Configurations > DetailLevel | Total |
| Configurations > ForwardForecastPeriod | 0 |
| Configurations > Order | 2 |
| General > Display | Front |
| General > Type | PolynomialTrendline |