In Excel, an absolute reference ... For positive growth figures, using the compound annual growth rate highlights increases off a steadily larger base. To use a simplistic example, a $100,000 ...