Excel Budget Chart: Build and Read It

An Excel budget chart compares planned spending with actual spending so you can see where money is on track and where it differs from the plan. In Microsoft Excel for Microsoft 365 on Windows, put categories, budget amounts, and actual amounts in adjacent columns, select the data, then choose Insert > Insert Column or Bar Chart > 2-D Column > Clustered Column.

What an Excel budget chart shows

A budget chart is a visual summary of figures stored in a worksheet, not a separate budgeting system. Its usefulness depends on the underlying numbers: the chart can show whether spending is near the planned amount, but it cannot determine whether a budget is realistic or whether a purchase was necessary.

The most straightforward comparison places two series side by side for each category: the planned budget and the actual amount spent. For example, a reader can quickly compare rent, groceries, transport, and utilities without scanning every number in a table. A chart is especially helpful when the workbook has several categories or months, or when someone needs to explain a budget to other people.

Charts work best alongside the worksheet figures rather than in place of them. Keep the amounts visible in cells, and use the chart to reveal patterns and exceptions. A large difference can be a cue to check the transactions, timing, or original estimate; it is not, by itself, an explanation of why the difference occurred.

Arrange the budget data clearly

Use one row per category and one column per measure. Put labels in the first row, use consistent units and periods, and avoid blank rows within the range that will feed the chart. Here is a small illustrative monthly budget in dollars:

Category	Budget	Actual
Rent	$1,500	$1,500
Groceries	$600	$640
Transport	$250	$220
Utilities	$300	$280

In a worksheet, place these headings in A1:C1 and the four category rows in A2:C5. The example has a total budget of $2,650 and actual spending of $2,640. The totals can be useful in the worksheet, but usually leave them out of a category chart: a total shown beside individual categories is not comparable to a single category and can make smaller bars harder to read.

Keep one reporting period consistent across the range. If the budget column is monthly, the actual figures should also cover that month, rather than a mix of monthly and year-to-date amounts. If transactions are recorded as positive expenses, keep them positive in both columns; inconsistent signs can make a correct comparison appear reversed.

Calculate the spending variance

A variance column provides a precise companion to the chart. Choose and label a convention before calculating it. In this example, variance means budget minus actual: a positive result means spending was below budget, and a negative result means spending exceeded budget. Some organizations use the opposite sign convention, so a clear heading such as “Budget less actual” prevents confusion.

With categories in A2:A5, budget values in B2:B5, and actual values in C2:C5, enter this formula in D2 to calculate the first category’s budget-minus-actual variance: =B2-C2. For Groceries, the result is -$40 because $600 minus $640 is -$40. Fill the formula down through D5 to calculate each remaining category.

A percentage can make differences easier to compare across categories of different sizes. With the same layout and the variance for the first category in D2, enter this formula in E2: =IF(B2=0,"",D2/B2). For Groceries, the result is about -6.7%: -$40 divided by the $600 budget. Format the result as a percentage using Home > Number, or the percentage button in the Number group. The formula leaves the result blank when the budget is zero, since a percentage of a zero budget is not a meaningful comparison.

With budget amounts in B2:B5, the formula =SUM(B2:B5) returns $2,650. With actual amounts in C2:C5, =SUM(C2:C5) returns $2,640. The overall budget-minus-actual difference is therefore $10 under budget. These total formulas can sit below the data, but do not include their row in the category chart unless you deliberately want a total displayed as another plotted item.

Create the chart in Excel

On Excel for Microsoft 365 for Windows, select the headers and category rows, A1:C5 in the example. Then use Insert > Insert Column or Bar Chart > 2-D Column > Clustered Column. Excel creates a chart with categories along the horizontal axis and separate columns for Budget and Actual. If Excel places the series and categories the wrong way around, select the chart and choose Chart Design > Switch Row/Column.

Give the chart a descriptive title, such as “April Budget vs. Actual,” and check that the legend clearly identifies both series. Select a chart element to use the Chart Elements button for options such as axis titles, data labels, or gridlines. An axis title such as “Amount ($)” helps make the measurement clear. Currency formatting in the source cells is generally useful, but check the chart axis too; chart number formatting may need to be adjusted separately through the axis formatting options.

For a chart that should expand as new categories are added, consider turning the data range into an Excel table. Select a cell in the data and choose Insert > Table, making sure the range includes the headers. Charts based on a table can include rows added to that table. Confirm the chart’s source range if new data does not appear, especially if the chart was created before the table or from a different range.

In Excel for Mac, select the same range and use the Insert tab’s chart controls; the chart options are broadly similar, though their placement and labels can vary by Excel release. Excel for the web also supports creating charts from selected data, but some detailed formatting controls may differ from the Windows desktop interface.

Choose the chart type for the question

A clustered column chart is a practical default when the goal is to compare budget and actual amounts across a manageable number of categories. Each category gets a pair of bars, so the difference is visible without calculating it mentally. A clustered bar chart uses horizontal bars instead and can be easier to read when category names are long.

A line chart is usually more suitable for a month-by-month trend than for a list of unrelated expense categories. Arrange the data with months in the first column and Budget and Actual in the next two columns, then create a line chart to see how each series changes over time. Use the same time interval for both series; comparing one month’s actual spending with a full quarter’s budget would be misleading.

A stacked chart answers a different question. It emphasizes how components contribute to a combined amount, rather than making the two values for each category easy to compare. Avoid using a pie chart to compare budget with actual across multiple categories: pie slices represent parts of a whole, while planned and actual amounts are two separate measures. The chart type should match the comparison, not simply look attractive.

Make the chart easier to interpret

Keep the design restrained. Use distinct, consistent colors for Budget and Actual, label the chart period, and avoid decorative effects that obscure the bar lengths. If readers might print the workbook in grayscale or have difficulty distinguishing colors, use clear series names and data labels or other visual distinctions rather than relying on color alone.

Sort categories in a meaningful order, such as largest budget first, or keep a familiar order such as housing, food, and transport.
Use the same currency and decimal precision throughout. Unnecessary decimal places can distract from whole-dollar planning.
Show data labels when exact values matter, but remove them if labels overlap or make the chart crowded.
Keep the vertical axis honest. A truncated axis can exaggerate modest differences between bars; for a straightforward budget comparison, an axis beginning at zero is often easier to interpret.
State the period and scope in the title or a nearby note, especially if the chart covers selected categories rather than all spending.

For a small difference, the chart may make the gap look larger or smaller than it is depending on scale and chart size. Read the source amounts and variance alongside the visual. A chart communicates relative size; it does not replace checking the actual values.

Common problems and how to fix them

If the chart shows category names as separate series, or the legend contains category names instead of Budget and Actual, Excel may have interpreted rows and columns differently. Use Chart Design > Switch Row/Column, then verify the axis labels and legend. Also confirm that the selected range includes the header row and all intended categories.

Unexpected blanks or missing categories can result from gaps in the source range, text stored where a number was expected, or a chart source that stops before the latest rows. Check that amounts are numeric values, not text with typed currency symbols, and inspect Chart Design > Select Data to review the chart’s source range. If a value is intentionally missing, decide whether the chart should show a gap or whether the underlying record needs completion.

When a bar is dramatically larger than the others, first check for a data-entry error or a mismatch in units—for example, entering an annual amount among monthly figures. If the amount is correct, consider whether the chart should be split into relevant groups or whether a different scale would help. Do not hide a valid expense just to make the remaining bars look more balanced.

Frequently Asked Questions

How do I make a budget versus actual chart in Excel?
Place categories in one column and budget and actual figures in the next two columns. Select the headers and rows, then choose Insert > Insert Column or Bar Chart > 2-D Column > Clustered Column. Check the chart title, legend, and category labels.

Which chart is best for a monthly budget?
Use a clustered column or bar chart to compare budget and actual across categories for one month. To compare how spending changes over several months, organize months as rows and consider a line chart with separate Budget and Actual series.

How do I show whether I am over budget?
Calculate budget minus actual in a variance column. A negative result indicates actual spending exceeded the budget under that convention; a positive result indicates spending was below it. Label the column clearly because other workbooks may use the reverse sign convention.

Can an Excel budget chart update when I add data?
It can if its source range includes the new rows or is based on an Excel table. If the chart does not update, inspect its source through Chart Design > Select Data and confirm that the added rows are within the source.

Should I include totals in the chart?
Usually not in a chart comparing individual categories, because the total is much larger than any one category and changes the scale. Keep totals in the worksheet, or make a separate summary chart if the total itself is the comparison readers need.

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.