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 meet the following requirements:
-
The chart must have a Date dimension on an axis.
-
The time period that is used must be higher than week (for example, month, quarter, or year).
-
There need to be at least two positive data points in the selected time period.
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
- Select your chart.
-
From the chart action menu (
), select .