Displaying the Compound Annual Growth Rate for a Chart

Show the Compound Annual Growth Rate for Bar/Column or Stacked charts.

Prerequisites

The chart must have a Date dimension on an axis.

Context

The Compound Annual Growth Rate (CAGR) is the ratio that provides a constant rate of return over the time period. You can add a CAGR line to your Bar/Column or Stacked Bar/Column chart.

Procedure

  1. Select your chart.
  2. From the chart action menu (), select Start of the navigation pathAdd Next navigation step CGREnd of the navigation path.

Results

A CAGR line is added to your chart. If you have changed the drill level for other dimensions, you may see separate CAGR lines instead of a continuous one.