Dynamic data ranges in an Excel Graph

An Excel Graph is a great way to communicate a company’s financial performance to stakeholders. A conventional Excel graph has a hard time updating for source data changes; unlike other Excel functions such as formulas or cell formats that update seamlessly. The introduction of dynamic data ranges in an Excel Graph will solve this problem.

DCF Sensitivity Analysis using Excel Data Table

The Excel Data Table “What-if Analysis” tool is one of the most powerful, yet underutilised functions in Excel. It is a great way to deliver a high-level, informative what if analysis of a company’s financial position such as its Net Present Value (NPV) from a Discounted Cash Flow (DCF) schedule.

How to create a Waterfall Chart in Excel

This article shows how to create a simple Waterfall Chart in Excel. It will apply the bar or column chart template with “Stacked Column” properties, which will produce an aesthetically pleasing graph of financial performance; based on a specified key performance indicator (KPI) over a selected time period i.e. EBITDA.