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
- Select your chart.
- From the chart action menu (), select .