Annual Growth rates from Linear Trendlines

In this post I’ll demonstrate how to generate annual growth rates based on historic linear trends. It effectively adds the % annual growth rate to a linear trendline produced on an excel chart.

Using Formulas to create a Dynamic Chart Title

The ability to use formulas in Excel chart titles is very limited and so most people tend to hard code their chart titles. The only formula you can use in the chart title is one that references another cell, for...