Skip to content

Is this the best way to show variances to budget and last year?

What’s the best way to bring variances to budget to life?

Stop using boring tables of numbers and try this instead…

My favourite finance chart is simple text, click here’s for that video.

My second favourite chart is the gap chart.

I think it’s the best way to show gaps to budget, target, and last year.

Way better than a table of numbers.

And you can use it for £ and %.

The gap chart isn’t a standard Excel chart, but you can download the Excel-hack template below.

Thanks to my client NHS Digital for the Excel template, I can’t take credit for it!

So the next time you want to show a gap, give the gap chart a go!

About Andy Shambrook

Hi I'm Andy. I used to be a finance director, then I became a sales director, and I'll show you everything I learned in sales that I wish I'd know when I worked in finance.

Leave a Comment

You must be logged in to post a comment.

Scroll To Top