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)
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.