Delta Charts in Excel
Create a delta chart in seconds using QI Macros add-in
Delta Charts show current and predicted performance versus benchmarks. Here is an example of QI Macros delta chart template:
* The example above uses healthcare data, showing performance against a core hospital measure - door to balloon time for angioplasty.
Why Use a Delta Chart?
Use Delta to show how current performance stacks up against the benchmarks.
- Enter your titles in B1 and F1.
- Put benchmark data in B2:B4 to create red-yellow-green bar.
- Put current and trended performance in F2:F3 to create diamond and triangle.