Help
Topics
Creating and Editing Trendlines
A trendline is a sloping line that is drawn between two or more points on a
chart. It can be used to identify trend and make projection based on the trend.
To add or edit a trendline:
- From the menu bar, select Chart > Trendlines....
The Edit Trendlines dialog pops up.
- If there are previously defined trendlines, they are displayed in the Available
Trendlines panel on the left. Click Add to add a
new trend line. Click on an existing trendline to edit it.
If no trendline has been defined, a trendline named "Trend_1" automatically
shows up in the Available Trendlines panel on the left for
you to define.
- See Trendline Options for details on trendline configuration.
To delete or rename a trendline:
- Select a trendline from the Available Trendlines panel and click Rename
or Delete button.
- Click OK for the change to be applied and exit the dialog.
 |
The name of the member used to plot the trendline
will be automatically appended to the end of the trendline name in square
brackets. |
Trendlines Options
For each trendline, you should define the following:
- Under the Type tab:
- Select a trend type.
- Select the member whose values are to be used to plot the trendline.
- Under the Style tab:
- Select a color from the color palette.
- Select a line type.
- Under the Options tab:
- Specify whether to replace the original data series. If this option
is selected, the original line or bar for the data series will not be
displayed.
- Specify number of forecast units.
- Click Apply to apply the changes, or OK
to apply the changes and exit the dialog.
Related Topics: