Logarithmic Trendline
In This Topic
A Logarithmic trendline creates a best-fit curved line that illustrates how data values increase or decrease and then level out. This trendline uses the following equation:
y=c ln x + b
where "c" and "b" are constants, and "ln" is the natural logarithm function.
| 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. |
| 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 a Logarithmic 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 | LogarithmicTrendline |