Finance chart template
Budget vs Actual Chart Template
Budgeted and actual expenses by month, useful for tracking spending against a plan.
Compare planned spending with what was actually spent, month by month. The template draws budgeted and actual expenses as two overlapping areas across the first half of the year.
Budget vs Actual Expenses
A live grouped area chart drawn from the sample data below. Click Edit this template to change it.
About this template
What the budget vs actual expenses chart shows
Over six months the sample spends $530,300 against a $526,000 budget, which is $4,300 or 0.8% over plan. Spending came in under budget in January, March and May and over budget in February, April and June.
June shows the widest gap, with $93,100 spent against a $90,000 budget. Plotting both series on the same axis makes each month's variance visible without a separate variance column.
About the sample data
Budget is the approved annual plan divided evenly across the months, and actuals come from the general ledger after month end close. Late invoices post to the month they are received, which pushes some spend into the following month.
Sample data
Sample data for the budget vs actual expenses template
The template loads these 12 rows. Keep the same columns, replace the rows with your own numbers, and the grouped area chart redraws to match.
Month
Time axis
Expense Type
Breakdown, one color per value
Amount
Values
| Month | Expense Type | Amount |
|---|---|---|
| 2026-01-01 | Budgeted | 85,000 |
| 2026-02-01 | Budgeted | 85,000 |
| 2026-03-01 | Budgeted | 88,000 |
| 2026-04-01 | Budgeted | 88,000 |
| 2026-05-01 | Budgeted | 90,000 |
| 2026-06-01 | Budgeted | 90,000 |
| 2026-01-01 | Actual | 82,500 |
| 2026-02-01 | Actual | 87,200 |
| 2026-03-01 | Actual | 86,800 |
| 2026-04-01 | Actual | 91,400 |
| 2026-05-01 | Actual | 89,300 |
| 2026-06-01 | Actual | 93,100 |
How to use it
How to adapt the budget vs actual expenses template
- 1 Click Edit this template to open the chart and its sample data in the InstaCharts chart maker. No account is needed.
- 2 Use one row per month per series, with Budgeted and Actual in an Expense Type column.
- 3 Load actuals after month end close so late invoices land in the right month.
- 4 Add a Forecast series for the remaining months to show where the year is heading.
- 5 Switch to a grouped bar chart if your audience prefers to read exact monthly values.
- 6 Download the chart as a PNG, SVG or PDF, share it with a link, or embed it on a website. Sign up free to save it.
FAQ
Budget vs Actual Expenses template FAQ
What is the best chart for budget vs actual?
A grouped bar chart or an overlapping area chart works well for monthly budget vs actual. Both put the two values for each month next to each other so the variance is easy to see.
Can I show the variance as its own chart?
Yes. Add a Variance column with actual minus budget and chart it as a bar chart with negative values in their own color.
Is this chart template free?
Yes. Click Edit this template to open it in the InstaCharts chart maker with no account needed. Sign up free to save the chart, share it with a link or embed it on a website.
How do I use my own data with this template?
Open the template in the chart maker, then paste in your own spreadsheet or upload a CSV or Excel file with the same kind of columns. The new chart keeps this template's grouped area chart type, and you can pick which columns go on each axis.
Learn more about this chart type on the grouped area chart maker page.
More templates
Related chart templates
Monthly Operating Expenses
Area ChartTotal operating expenses for each month over a full year.
View templateDepartment Budget by Expense Type
Horizontal Stacked Bar ChartHow each department's annual budget splits across salaries, software, travel and equipment, stacked into horizontal bars.
View templateCash Flow Waterfall
Waterfall ChartNet cash flow for each month of the year, shown as a waterfall of rises and drops building toward the ending balance.
View templateMonthly Operating Budget Spent
Needle Gauge ChartOne month of operating expenses added up and shown on a needle gauge, with the monthly budget marked as the target.
View templateStock Price Trend
Line ChartDaily closing price for a sample stock ticker over several weeks of trading.
View templateMarketing Budget Allocation
Semi Circle Donut ChartAnnual marketing budget split across five channels, shown as a half donut.
View templateSee all Finance Chart Templates, or browse all chart templates.
Make your own grouped area chart in seconds
InstaCharts makes data visualization easy, so you can build clear reports without design experience.