Adding a Trend Line

Trend lines on charts can be lines of best fit through historical data or growth rate lines that increase historical data by a specified percentage.

To add trend lines to a chart:

  1. In the Edit View or New View dialog, click Add Trend Line.
  2. In Add Trend Line, select Linear trend line or Growth rate.

    The sample chart shows the effect of your selection.

  3. Optional: If you select Growth rate, specify the rate (2% is the default) and the time dimension (Year is the default). To compound growth by adding the previously calculated percentage to the current baseline value when calculating the next value, select Use compounding. By default, this setting is not selected.
  4. Click OK.