Mekko Graphics makes using CAGRs easy. The CAGR column feature allows you to line up the data with your chart and you can calculate the CAGR directly in the Mekko Graphics data sheet. Save time and avoid the hassle of using a manual formula in Excel by using this feature. Simply type this formula in the CAGR column cells:
=cagr(first data point, last data point, # of years)
Note: # of years should be calculated as the ending year minus the beginning year. So, if your data is from 2010 to 2016, the value for # of years is 6.
You can also add a legend to your chart and have it align with your CAGR column. Under Format Legend, select Align to CAGR from the Position menu.
Check out this video to learn more about using CAGRS.