Ampler Charts adds a CAGR (compound annual growth rate) arrow to a chart, so the growth rate over the period is shown on the exhibit rather than left for the reader to work out.
Quick answer: Right-click the chart and select Add CAGR; drag a handle to position it, or add a CAGR to specific columns by selecting one segment on each column, right-clicking, and choosing Add CAGR.
How to use it
Right-click to add a CAGR, then drag it into position.
- Right-click on the chart and select Add CAGR.
- Move a CAGR by dragging a handle into position.
- To add a CAGR to specific columns, select one segment on each column, right-click, and select Add CAGR.
The CAGR arrow shows the compound annual growth rate between the chosen columns, calculated automatically.
When to use it
Add a CAGR when growth over the period is the message — it puts the compound rate directly on the exhibit so the reader doesn’t have to compute it. Add CAGRs between specific columns to show growth over a chosen span rather than the whole chart.
How consultants use it
The growth arrow is one of the most recognisable elements of a consulting chart — it states the “so-what” of a trend. Three habits apply:
- Show the growth rate: the CAGR states the trend’s magnitude on the chart itself
- Choose the span deliberately: a CAGR between specific columns frames the period that matters
- Let the tool do the maths: the rate is calculated automatically, so it can’t be mis-typed
A CAGR arrow puts the growth story on the chart, calculated for you.
Tips & best practices
- Add CAGRs between the columns whose growth is the point.
- Keep the CAGR label format consistent across charts.
- Use Add series CAGRs when each series needs its own growth rate.
Availability
Part of Ampler Charts, included in Ampler for PowerPoint and the Ampler Suite, on Windows desktop PowerPoint.
Frequently asked questions
How do you add a CAGR to a chart in PowerPoint?
Right-click the chart in Ampler Charts and select Add CAGR. Ampler calculates the compound annual growth rate and shows it as an arrow you can drag into position.
What is a CAGR arrow on a chart?
A decorator showing the compound annual growth rate between two columns — the constant yearly rate at which the value grew over the period, calculated automatically.
How do you add a CAGR between specific columns?
Select one segment on each of the columns, right-click, and choose Add CAGR to show the growth over just that span.
Does the CAGR update if the data changes?
Yes. Ampler calculates the CAGR from the chart data, so it reflects the underlying values.