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).