Variance analysis example

Here is an example file of a variance analysis I had to do recently, including raw data.


It works pretty well, although I would prefer to have separate reports for sales and margin, and not split in 2 consecutive lines like here.

The file is available here.

Note : this file does not contain any code. The Sparklines add-in must be installed before using it.
I modified the code on my machine in order to identify bars that have in this case more than 100% variance (white triangle in the screenshot).