Free Budget vs Actual Variance Chart Template for Excel
Free budget vs actual variance chart template for Excel. Pre-built formulas, a clustered column and diverging variance chart, and no email wall.
Free Budget vs Actual Variance Chart Template for Excel
Most budget vs actual templates you’ll find are either locked behind an email wall or built so rigidly that adding a single line item breaks the chart. This one isn’t. It’s an unlocked Excel file with the variance math already wired in and two charts that redraw the moment you type your own numbers. Scroll to the bottom and it’s yours — no signup.
But download it in a second. First, the two-minute version of what a good budget vs actual chart actually needs, because a chart that just shows two bars side by side is doing half the job.
What the template contains
The workbook has one job: turn a budget-versus-actual table into a picture that makes overspending impossible to miss. It comes with:
A P&L-style table with realistic sample data — revenue and expense lines — so you can see the structure before you overwrite it. The blue cells are yours to edit; everything else is a formula.
| Line Item | Budget | Actual | Variance | Variance % |
|---|---|---|---|---|
| Product Sales | 50000 | 52000 | 2000 | 4.0% |
| Service Revenue | 20000 | 18000 | -2000 | -10.0% |
| Salaries | 30000 | 30000 | 0 | 0.0% |
| Marketing | 10000 | 12000 | -2000 | -20.0% |
A variance column (Actual − Budget) and a variance % column ((Actual − Budget) / Budget), both pre-built with divide-by-zero protection so nothing breaks when a line reads zero.
A favourable / unfavourable split that’s the quiet workhorse of the file. It knows that for revenue lines, coming in above budget is good, while for expense lines, coming in below budget is good — and it colors the variance accordingly. That single piece of logic is what most free templates get wrong, showing every over-budget number in red even when it’s revenue you wanted to beat.
Two ready-made charts: a clustered column chart comparing budget and actual for each line item, and a diverging variance bar chart that pushes favourable variances one way in green and unfavourable ones the other way in red.
How to use it
Once you’ve downloaded the file, it takes about five minutes to make it yours.
- Replace the sample line items in column B with your own — your revenue streams, your cost categories, whatever your chart of accounts looks like.
- Type your budget figures into the blue Budget column and your actuals into the blue Actual column. That’s the only typing you do.
- Watch the rest fill in. Variance, variance %, the favourable/unfavourable split, and both charts update automatically. The totals row at the bottom sums everything.
- Add or remove rows as needed. Insert rows inside the existing table range (not below the total) so the formulas and chart ranges pick them up. If you add a row at the very bottom, drag the formulas down and extend the chart’s data range once.
That’s it. No macros, no add-ins, no locked cells fighting you.
Which variance chart should you actually use?
This is where a bit of opinion earns its place, because “budget vs actual chart” covers several designs and they are not equally good.
The clustered column chart — budget and actual as paired bars per category — is the default everyone reaches for, and it’s fine. It’s honest, it’s readable, and your audience already knows how to read it. Use it when you’re presenting to people who just want to see the two numbers next to each other. The template includes this one because it’s what most readers expect to hand to a manager.
The diverging variance bar chart — showing only the gap, pushed left or right from a center line — is usually the better choice and almost nobody uses it. When you plot variance directly instead of plotting budget and actual and asking the viewer to do the subtraction in their head, the story jumps off the page: everything red on one side is a problem, everything green on the other side is a win. If you’re trying to drive a decision rather than just report numbers, this is the chart. The template includes it too, so you can try both on the same data and see which lands.
What we’d steer you away from: cramming budget, actual, prior year, and forecast into one four-bar cluster per category. It feels thorough and reads like noise. If you genuinely need all four, that’s a dashboard job, not a single chart — more on that below.
One design rule worth stealing regardless of chart type: use color to mean something. Red should mean “this needs attention,” not “this is a number.” The template’s favourable/unfavourable coloring does this automatically, so a manager scanning it for three seconds sees the two lines that matter and ignores the rest.
Download the template
Here’s the file — a complete budget vs actual variance workbook with the table, the formulas, and both charts built and tested.
It’s unlocked, macro-free, and there’s no email gate. Open it, overwrite the blue cells, and your charts are done.
Where to go from here
A single variance chart answers “how did we do against budget?” for one set of numbers. If you’re doing this every month across several departments or KPIs, you’ll quickly want the numbers, the charts, and a few filters living together on one screen. That’s a dashboard, and we walk through building one — variance charts included — in our budget vs actual dashboard in Excel tutorial. It picks up exactly where this template leaves off.
If the dashboard you’re picturing is broader than budgeting — sales, operations, headcount, the lot — start instead with the general KPI dashboard in Excel walkthrough, which covers the data-prep and layout foundations that make any dashboard maintainable.
And if you’ve hit the point where you’re rebuilding the same reports every month and wondering whether a proper BI tool would be less painful, we’ve written an honest Power BI vs Excel for charts and dashboards comparison. The short version: for a monthly budget variance report, Excel is almost certainly still the right tool — but there’s a clear line where that stops being true, and it’s worth knowing where it is before you invest in either direction.
Frequently asked questions
Is the template really free with no email required? Yes. Click the download link, get the file. No signup, no watermark, no locked cells.
Which Excel versions does it work in?
Any version from Excel 2016 onward, including Microsoft 365 and Excel for Mac. The formulas used (SUM, IF, IFERROR) work everywhere, and both charts are standard chart types with no add-ins needed.
Can I change the sample data to my own chart of accounts? That’s the intended use. Overwrite the line-item names and the budget/actual figures in the blue cells; everything recalculates. Insert new rows inside the existing table so the formulas and chart ranges extend automatically.
Why are some over-budget numbers green instead of red? Because the template distinguishes revenue lines from expense lines. Beating budget on revenue is favourable (green); exceeding budget on an expense is unfavourable (red). This is deliberate, and it’s the thing generic templates get wrong.
What’s the difference between the two charts? The clustered column chart shows budget and actual side by side so viewers can compare the raw numbers. The diverging variance chart shows only the gap between them, color-coded by whether it’s good or bad — better for driving a decision. Use whichever fits your audience; the file has both.
Can I add more months or a year-to-date view? Yes, though at that point you’re building a dashboard rather than a single chart. Our budget vs actual dashboard tutorial covers multi-period variance views, running totals, and conditional flags.