How to Create a Budget vs Actual Chart in Excel

Tracking your spending against your budget is one of the most fundamental tasks in managing your business finances. But staring at rows of numbers in a spreadsheet doesn't always tell the full story. To truly understand your performance at a glance, you need to visualize it. This guide will walk you through, step-by-step, how to create a clear and insightful budget vs. actual chart directly in Excel.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

First Things First: Set Up Your Data For Success

Before you can make a chart, you need to organize your data in a way Excel understands. A poorly structured table will cause headaches, so taking a minute to set it up correctly is the most important step.

Create a simple table with at least four columns. For this example, we'll track monthly expenses:

• Month: The time period (e.g., January, February, March).
• Budget: The amount you planned to spend.
• Actual: The amount you actually spent.
• Variance: The difference between your budget and actual spend.

Your table should look something like this:

How to Quickly Calculate Variance

The "Variance" column shows you exactly how much you were over or under budget. This is where a simple formula comes in handy.

In the first cell of your Variance column (cell D2 in your example), type the following formula:

=C2-B2

This formula subtracts the budgeted amount (B2) from the actual amount (C2).

• A positive number ($300) means you spent $300 more than you budgeted (over budget).
• A negative number (-$200) means you spent $200 less than you budgeted (under budget).

Once you've entered the formula in the first cell, click on the small green square at the bottom-right corner of the cell and drag it down to apply the formula to the rest of the column. No need to re-type it for every row.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step-by-Step: Creating a Budget vs. Actual Combo Chart

Now for the fun part. A “combo chart” - which combines two chart types, like columns and a line - is perfect for visualizing budget vs. actuals. It lets you see the planned budget as a steady baseline and the actual spending as a trend line over it.

1. Select Your Data

Click and drag your mouse to highlight the primary data you want to chart. For our first chart, just select the Month, Budget, and Actual columns, including the headers.

Pro Tip: Don't select the Variance column just yet. We'll add that later in a more visually effective way.

2. Insert the Chart

With your data highlighted, navigate to the Insert tab on Excel's ribbon. In the Charts section, click on the Recommended Charts button.

Excel will often suggest a "Clustered Column" chart by default. While this chart type works, it can sometimes be hard to see the trend in your actual spending. We can do better.

In the 'Insert Chart' window, click on the All Charts tab at the top. From the list on the left, select Combo at the bottom. This is the ideal format for this kind of comparison.

3. Configure the Combo Chart

You’ll now see a configuration menu for your combo chart. This lets you decide how each piece of data (each "series") is displayed.

• For the 'Budget' Series: Set the Chart Type to Clustered Column. This will represent your budget as solid, stable bars - a foundation for each month.
• For the 'Actual' Series: Set the Chart Type to Line with Markers. Using a line shows the flow and trend of your actual spending over time and makes it easy to see if you are consistently trending above or below your budget.

Your preview should now show sturdy columns for the budget targets and a connecting line showing the journey of your actual spending. Click OK to create the chart and insert it into your worksheet.

You now have a functional budget vs. actuals chart. But with a few small tweaks, we can make it much more powerful.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Level Up Your Chart with Enhancements

A basic chart is good, but a great chart provides deep insight at a glance. Let’s add context and improve clarity.

Add Clear Titles and Axis Labels

A chart without labels is just a picture. Give it a clear, descriptive title.

1. Click on the default "Chart Title" at the top and change it to something specific, like "Monthly Expenses: Budget vs. Actual - Q1 2024".
2. If Excel hasn't added them automatically, add axis labels. Click on the chart area, then click the green '+' icon that appears on the right. Check the box for Axis Titles.
3. Label your vertical (Y-axis) with "Amount ($)" and your horizontal (X-axis) with "Month". This leaves no room for misinterpretation.

Use Color Strategically

Color theory isn't just for artists, it can make your financial reports much more intuitive.

• For Budget Columns: Use a neutral color, like a muted gray or light blue. The budget is your baseline - it should be stable and in the background.
• For the Actual Line: Use a stronger, more prominent color, like a bold blue, orange, or your company's primary brand color. The actual performance is the main story here, so make it stand out.

To change the color of a series, simply right-click on one of the columns (or the line) and select Format Data Series. A panel will appear on the right side. Click the paint bucket icon to access the Fill & Line options and choose your desired colors.

Visualizing Variance for Deeper Insights

Seeing the budget and actuals is great, but highlighting the difference between them is where the real analysis begins. Let's add that 'Variance' data you calculated earlier to the chart.

An Advanced Two-in-One Chart

We are going to add the variance to what is called a "secondary axis." This will let you show the dollar variance without cluttering up your primary axis, perfect for when the variance numbers are much smaller than the budget and actual numbers.

1. Add the Variance Data: Right-click on your chart and choose Select Data. In the pop-up box, click the Add button. For the 'Series name', click on the header for your variance column. For the 'Series values', select all the data in your variance column. Click OK. Excel will likely add it as another column, which can look messy, but don't worry, we're about to fix that.
2. Change the Variance Chart Type: Right-click your chart again and choose Change Chart Type. This takes you back to the Combo menu. You'll now see your 'Variance' series listed. Change its Chart Type to a Clustered Column.
3. Move it to the Secondary Axis: This is a key step. In that same row for Variance, check the Secondary Axis checkbox on the right. You'll see Excel add a new number scale on the right side of your chart specifically for the variance values. Click OK.

What you have now is incredibly powerful: a single chart that shows your budgeted plan, your actual performance trend, and the magnitude of your over/under spend each month.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Bonus Tip: Use Conditional Formatting in the Table

To support your chart, use conditional formatting in your data table to instantly highlight overspending and underspending.

1. Highlight the numbers in your 'Variance' column.
2. Go to the Home tab on the ribbon.
3. Click Conditional Formatting > Highlight Cells Rules > Greater Than...
4. Type 0 in the box, and in the dropdown, select Light Red Fill with Dark Red Text. Click OK. Since a positive variance means overspending, it now gets flagged in red.
5. Repeat the process, but this time select Less Than..., type 0, and choose a green format. Now, any underspending will be highlighted in green.

Your table now works with your chart to give a complete, color-coded picture of your financial performance.

Final Thoughts

Creating a budget vs. actual chart in Excel transforms your financial data from a simple list of numbers into a strategic tool for decision-making. By following these steps to structure your data, choosing a combo chart, and adding variance for context, you've built a report that is clear, insightful, and easy to maintain.

Regularly updating these reports manually can be time-consuming, especially as you start tracking more campaigns, departments, or revenue streams. At Graphed , we automate this entire process. Instead of downloading CSVs and building charts in Excel every week, you connect your data sources once, and we provide real-time dashboards that update automatically. You can just ask for what you need - "create a chart comparing my marketing ad spend to my budget this quarter" - and get an interactive visualization back in seconds, freeing you up to focus on strategy, not spreadsheets.