Budget vs actual: the chart that survives a finance review
Almost every budget-versus-actual chart shows two bars per category and asks the reader to do arithmetic. The information people want is the gap, so draw the gap.
Variance bars beat paired bars
One bar per category, centred on zero, extending right when you overspent and left when you came in under. Sorted by size, it becomes a ranked list of what went wrong, which is the meeting agenda.
Keep paired bars for the summary slide
There is one case where side-by-side bars are right: when the absolute sizes matter as much as the gap, typically at the total level. Below the total, variance wins.
Decide what red means before you start
Overspending on costs is bad; overshooting on revenue is good. If both live in one chart, the same colour ends up meaning both, so split them into two charts or label the direction explicitly.
Percentage or absolute?
Absolute for anything anyone has to fund, percentage for comparing departments of different sizes. Showing both in one chart usually means neither is read.
- One variance bar per category, sorted by magnitude.
- Zero line visible and centred.
- Costs and revenue in separate charts.
- Absolute amounts for decisions, percentages for comparisons.
The test is simple: can someone name the three biggest problems within five seconds of seeing the chart? If not, you are still asking them to do the subtraction.
Frequently asked
What chart type is best for budget versus actual?
A sorted variance bar chart for detail, and paired bars only at the summary level where absolute sizes matter as much as the gap.
Should over-budget be red or green?
Red for costs and green for revenue, which is why they belong in separate charts. One chart cannot make the same colour mean both good and bad.