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

Sample data for the Department Budget by Expense Type chart template
DepartmentExpense TypeAmount
EngineeringSalaries2,450,000
Sales and MarketingSalaries1,780,000
Customer SupportSalaries960,000
Finance and LegalSalaries720,000
People OperationsSalaries540,000
EngineeringSoftware420,000
Sales and MarketingSoftware260,000
Customer SupportSoftware145,000
Finance and LegalSoftware110,000
People OperationsSoftware95,000
EngineeringTravel85,000
Sales and MarketingTravel310,000
Customer SupportTravel42,000
Finance and LegalTravel38,000
People OperationsTravel52,000
EngineeringEquipment190,000
Sales and MarketingEquipment95,000
Customer SupportEquipment60,000
Finance and LegalEquipment25,000
People OperationsEquipment20,000

How to use it

How to adapt the department budget by expense type template

  1. 1 Click Edit this template to open the chart and its sample data in the InstaCharts chart maker. No account is needed.
  2. 2 Use one row per department per expense type with the budget amount in a number column.
  3. 3 Keep shared costs like rent and insurance in their own row or leave them out, and say which in the caption.
  4. 4 Switch to a 100% stacked bar to compare each department's mix regardless of its size.
  5. 5 Use horizontal bars when department names are long.
  6. 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.

Make your own horizontal stacked bar chart in seconds

InstaCharts makes data visualization easy, so you can build clear reports without design experience.