The best chart for budget vs actual is usually a bullet chart when you're comparing many line items at once, or a grouped bar chart when you only have a handful. Both put the budgeted amount and the actual amount side by side so a reader can see the gap directly, instead of having to subtract two numbers in their head.
Budget vs actual data is any pair of numbers where one column is a target or plan and the other is what really happened: department spend against a set budget, project cost against an estimate, sales against quota. The chart that works depends mostly on how many rows you're comparing at once and whether you also want to show a qualitative range like "under budget" or "over budget" at a glance.
This guide covers the chart types built for this comparison, a decision guide for picking between them, the mistakes that make budget charts misleading, and how to build one from your own spreadsheet.
What Is Budget vs Actual Data?
Budget vs actual data pairs a planned figure with the real figure it's meant to track, for the same line item and the same period. A finance team compares a department's approved budget against what it actually spent this quarter. A project manager compares an estimated cost against the cost so far. A sales team compares quota against closed revenue. In every case there are two numbers per row: the plan and the result.
What makes this different from a plain comparison is the third thing every reader wants from the chart: not just the two values, but the gap between them, usually called the variance. A chart that only shows two bars per row and makes the reader estimate the difference by eye is doing half the job. The strongest options for this data build the variance into the chart itself.
The Best Chart Types for Budget vs Actual
A few chart types handle a planned-vs-actual pair well. Which one fits depends mainly on how many rows you have and whether you need a qualitative range (good, warning, over) alongside the raw numbers.
| Chart Type | Best For | Example |
|---|---|---|
| Bullet chart | Many line items, each needing a compact actual-vs-target row | Departmental spend across 20 cost centers |
| Grouped bar chart | A handful of categories, general audience | Budget vs actual for 5 project phases |
| Waterfall chart | Explaining how the total variance builds up across line items | Full-year budget bridging to actual spend |
| Gauge chart | A single metric against its target, for a dashboard tile | Total quarterly spend vs total budget |
A plain grouped bar chart is the most familiar of these, since most readers already know how to compare two adjacent bars. A bullet chart trades a little of that familiarity for density: it fits far more line items into the same vertical space and adds performance-range shading (poor, satisfactory, good) that a grouped bar can't show without a legend.
Which Chart Should You Use for Budget vs Actual?
Quick answer: under roughly 10 to 15 categories, a grouped bar chart is the easiest for most readers to interpret without explanation. Past that, switch to a bullet chart so each row stays readable.
- Comparing 5 to 15 categories for a general audience → grouped bar chart, one bar for budget and one for actual per category. See the full stacked vs grouped bar chart guide for when a stacked layout works better instead.
- Comparing dozens of line items at once → bullet chart, which compresses each comparison into a single labeled row.
- Explaining how a total variance built up across several line items → waterfall chart, which shows each item's contribution to the final gap rather than comparing items side by side.
- A single headline number for a dashboard → gauge chart, useful for one KPI but not for comparing multiple line items at once.
- Tracking budget vs actual over time, not by category → a line chart with two series, one for cumulative budget and one for cumulative actual spend.
Still unsure which fits your dataset as a whole, not just this comparison? The broader financial data visualization guide covers chart selection across finance use cases.
Bullet Chart vs Grouped Bar Chart
These two get compared most often because both work for the same underlying data, just at different scales. A grouped bar chart uses two full bars per category, so it's immediately readable but takes up more horizontal space per comparison. A bullet chart replaces the second bar with a thin target tick mark on top of a single bar, which is more compact but asks the reader to learn one new convention first.
The tradeoff shows up fastest once you add qualitative context. A bullet chart can shade the background in bands for poor, satisfactory, and good performance, so a reader can tell at a glance whether a department is meaningfully over budget or just slightly off, without reading the numbers. A grouped bar chart has no natural place to put that shading, so you'd need a separate legend or color-coded bars instead. For a report going to people who read it daily, that density pays off. For a one-off slide to an audience seeing the format for the first time, the grouped bar chart's familiarity usually wins.
Common Mistakes to Avoid
Using a Pie Chart for Budget vs Actual
A pie chart shows how parts add up to a whole, which isn't what budget vs actual is about. Budget and actual aren't two slices of one total, they're two separate measurements of the same thing. A pie chart forces them into a part-to-whole relationship that doesn't exist and hides the variance entirely.
Not Showing Variance Direction
Two bars of similar height next to each other still make the reader do subtraction. Adding a variance value, or coloring bars differently when actual exceeds budget versus falls short of it, turns a chart that requires math into one that answers the question directly.
Truncating the Axis to Exaggerate Small Gaps
Starting the y-axis above zero makes a 2% variance look like a 40% one. This is a common way budget charts end up misleading, intentionally or not. Keep the axis at zero unless every value in the dataset sits far from it and the truncation is clearly labeled.
Charting Every Line Item at Once
Fifty line items on one chart, in any format, buries the ones that actually matter. Sort by the size of the variance and show the largest gaps first, or group smaller items into an "other" category, the same way you would with too many pie slices.
How to Create a Budget vs Actual Chart From Your Data
Step 1: Arrange Your Data by Line Item
You need one column of category labels (department, project phase, cost center) and two numeric columns: budgeted amount and actual amount. A third optional column for the qualitative range thresholds helps if you're building a bullet chart.
Step 2: Upload, Paste, or Link the File
CleanChart accepts CSV, Excel, ODS, JSON, XML, YAML, TSV, and Markdown files, plus data pasted from the clipboard or a linked Google Sheet. For a CSV specifically, the CSV to bullet chart converter and CSV to waterfall chart converter handle the upload directly.
Step 3: Accept or Override the Suggested Chart
CleanChart recommends a chart type with a confidence score based on your data's shape, and automatic cleaning catches duplicate rows, missing values, and type mismatches like numbers stored as text first. You can override the suggestion at any point if you'd rather build a bullet chart than the grouped bar it proposes, or the reverse.
Step 4: Customize and Export
Adjust colors, labels, gridlines, and reference lines so the target and actual values stay easy to tell apart, then export. Free exports are a watermarked PNG at reduced resolution with no limit on how many you create; a paid plan adds clean, high-resolution PNG and SVG, with PDF export included as a premium feature.
For a longer walkthrough of the bullet chart format specifically, see the complete guide to creating a bullet chart.
Frequently Asked Questions
What is the best chart for budget vs actual?
A bullet chart if you're comparing many line items at once, since it fits a target tick and a performance range into one compact row. A grouped bar chart if you only have a handful of categories and want something a general audience recognizes immediately.
Should I use a bar chart or a bullet chart for budget vs actual?
Use a grouped bar chart under roughly 10 to 15 categories, since two full bars per item stay easy to compare without a legend. Past that count, a bullet chart keeps each row readable in less vertical space, and adds qualitative shading a bar chart can't show on its own.
How do I show whether a variance is over or under budget?
Color the bar or bullet differently depending on direction, for example one color when actual exceeds budget and another when it falls short, or add the variance amount as a data label next to each row. Either approach removes the need for the reader to subtract two numbers themselves.
Can I use a pie chart to show budget vs actual?
Not really. A pie chart represents parts of a whole, and budget and actual aren't two parts of one total, they're two separate measurements of the same line item. A grouped bar or bullet chart shows the comparison directly; a pie chart hides it.
Related CleanChart Resources
- How to Create a Bullet Chart – a full walkthrough of the format that scales best for many budget line items
- How to Create a Waterfall Chart – for showing how a total variance builds up across line items
- Stacked vs Grouped Bar Charts – the decision rules for a handful of budget categories
- Financial Data Visualization – chart selection across the rest of finance reporting
- Project Management Charts – budget tracking alongside timelines and progress
- Best Chart for Tracking Progress – choosing between gauge, bullet, line, and funnel charts for any goal-based metric
CleanChart accepts CSV, Excel, JSON, and several other formats directly, cleans up common issues like inconsistent types automatically, and suggests a chart type with a confidence score you can override. Uploads are processed over HTTPS without being written to disk or kept as a stored copy of the rows. Try CleanChart with your own budget vs actual data to see the suggested chart in a couple of minutes.
External Resources
- Budget – Wikipedia – the general definition of a budget and how variance against it is tracked
- Bar Chart – Wikipedia – history and standard conventions for the grouped bar format
- data-to-viz.com – a chart-selection reference organized by data type
Have a spreadsheet of budgeted and actual figures sitting in a report file? Paste it into CleanChart and see which chart type it recommends before you build one by hand.