Finance chart template
Department Budget Chart Template
How each department's annual budget splits across salaries, software, travel and equipment, stacked into horizontal bars.
Show how each department's annual budget breaks down across salaries, software, travel and equipment. Each department is one stacked horizontal bar, with a segment for each expense type.
Department Budget by Expense Type
A live horizontal stacked bar chart drawn from the sample data below. Click Edit this template to change it.
About this template
What the department budget by expense type chart shows
Engineering holds the largest budget in the sample at $3.15 million, followed by Sales and Marketing at $2.45 million. Across the company, salaries make up $6.45 million of the $8.40 million total, about 77%.
Sales and Marketing has the largest travel budget at $310,000, more than three times Engineering's $85,000. Stacked bars show both the total and the mix, so differences like this stand out.
About the sample data
Figures are the approved annual budget set at the start of the fiscal year rather than spend to date. Shared costs such as facilities and insurance sit in a central pool and are not allocated to departments here.
Sample data
Sample data for the department budget by expense type template
The template loads these 20 rows. Keep the same columns, replace the rows with your own numbers, and the horizontal stacked bar chart redraws to match.
Department
Categories
Expense Type
Breakdown, one color per value
Amount
Values
| Department | Expense Type | Amount |
|---|---|---|
| Engineering | Salaries | 2,450,000 |
| Sales and Marketing | Salaries | 1,780,000 |
| Customer Support | Salaries | 960,000 |
| Finance and Legal | Salaries | 720,000 |
| People Operations | Salaries | 540,000 |
| Engineering | Software | 420,000 |
| Sales and Marketing | Software | 260,000 |
| Customer Support | Software | 145,000 |
| Finance and Legal | Software | 110,000 |
| People Operations | Software | 95,000 |
| Engineering | Travel | 85,000 |
| Sales and Marketing | Travel | 310,000 |
| Customer Support | Travel | 42,000 |
| Finance and Legal | Travel | 38,000 |
| People Operations | Travel | 52,000 |
| Engineering | Equipment | 190,000 |
| Sales and Marketing | Equipment | 95,000 |
| Customer Support | Equipment | 60,000 |
| Finance and Legal | Equipment | 25,000 |
| People Operations | Equipment | 20,000 |
How to use it
How to adapt the department budget by expense type 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 department per expense type with the budget amount in a number column.
- 3 Keep shared costs like rent and insurance in their own row or leave them out, and say which in the caption.
- 4 Switch to a 100% stacked bar to compare each department's mix regardless of its size.
- 5 Use horizontal bars when department names are long.
- 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
Department Budget by Expense Type template FAQ
How do I chart a budget by department and category?
Put the department in one column, the expense type in a second column and the amount in a third. A stacked bar chart uses the department for the bars and the expense type for the segments.
Can I compare budget and actual for each department?
Yes. Add an Actual column, or a Budget or Actual column with both values, and switch to a grouped bar chart.
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 horizontal stacked bar chart type, and you can pick which columns go on each axis.
Learn more about this chart type on the stacked bar chart maker page.
More templates
Related chart templates
Budget vs Actual Expenses
Grouped Area ChartBudgeted and actual expenses by month, useful for tracking spending against a plan.
View templateMonthly Operating Expenses
Area ChartTotal operating expenses for each month over a full year.
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 horizontal stacked bar chart in seconds
InstaCharts makes data visualization easy, so you can build clear reports without design experience.