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:

  1. From the menu bar, select Chart > Trendlines....
    The Edit Trendlines dialog pops up.
  2. 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.
  3. See Trendline Options for details on trendline configuration.

To delete or rename a trendline:

  1. Select a trendline from the Available Trendlines panel and click Rename or Delete button.
  2. Click OK for the change to be applied and exit the dialog.
Tip

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:

  1. Under the Type tab:
  2. Under the Style tab:
  3. Under the Options tab:
  4. Click Apply to apply the changes, or OK to apply the changes and exit the dialog.

 

Related Topics: