Exponential Trendline
In This Topic
An Exponential trendline creates a best-fit curved line that illustrates how data values increase or decrease and then level out. You can use this trendline only with positive numbers. If the data series contains any zero or negative numbers, then this trendline is not available.
This trendline uses the following equation:
y=cebx
where "c" and "b" are constants, and "e" is the base of the natural logarithm.
| 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. |
|
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 an Exponential 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 |
| General > Display | Front |
| General > Type | ExponentialTrendline |