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.
charts
A collection of 7 posts
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...
Using Ramp-Up Profiles for QIPP Savings and Expenditure
You can use this ramp up trick to apply a phasing profile to planned expenditure but I am illustrating it here to model the monthly delivery of planned savings. In the NHS we tend to refer to savings as either...
Forecasting using Excel's Linear Trendline
Excel offers the option to insert a series of trendlines on your charts.
The Double Bridge - An Excel Waterfall Template
It seems that each NHS planning round inspires me to produce yet another Excel Bridge template.