How to Make a Budget Pie Chart in Excel

A budget pie chart is a simple yet powerful way to quickly see where your money is going. With just a glance, you can understand the major spending categories and their proportion to the whole. This detailed guide walks you through every step of creating and customizing a useful budget pie chart in Microsoft Excel.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Setting Up Your Budget Data in Excel

Before you can make a chart, you need clean, well-organized data. A pie chart visualizes parts of a whole, so your spreadsheet should have two simple columns: one for your budget categories (the parts) and one for their corresponding amounts (the whole).

Let's use a simple personal monthly budget as an example. Your data should look something like this:

• Column A: Category
• Column B: Amount

Here’s the sample data we’ll use for this tutorial. Open a new Excel sheet and input this information:

A1: Category B1: Amount

A2: Rent/Mortgage B2: 1200

A3: Groceries B3: 450

A4: Utilities B4: 150

A5: Transportation B5: 200

A6: Entertainment B6: 175

A7: Savings B7: 250

Tips for Structuring Data

• Keep it Simple: Don’t include a "Total" row in your selection when creating the chart. Excel automatically calculates the total when building the pie. Including it will create a massive slice that represents 50% of the chart, throwing off your entire visual.
• Be Clear: Use descriptive names for your categories. "Rent" is much clearer than "Housing Cost 1." This makes your chart's legend and labels instantly understandable.
• Use Raw Numbers: Enter the actual dollar amounts. Don't worry about calculating percentages beforehand — Excel will do that for you when you format the chart labels later.

How to Create a Budget Pie Chart in 5 Simple Steps

Once your data is neatly organized in two columns, creating the actual pie chart takes less than a minute. Excel’s charting tools are designed to be intuitive and fast.

Step 1: Select Your Data

Click and drag your cursor to highlight all the cells containing your data, including the headers. In our example, you would select the range A1:B7.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step 2: Go to the Insert Tab

At the top of the Excel window, click on the Insert tab in the ribbon.

Step 3: Find the Charts Group

Look for the section in the ribbon labeled "Charts." You'll see icons representing different types of charts like bar, line, and pie charts.

Step 4: Click the Pie Chart Icon

Click on the small icon that looks like a pie chart. A dropdown menu will appear showing several options.

Step 5: Choose Your Chart Style

You’ll have a few choices under groupings like 2-D Pie, 3-D Pie, and Doughnut.

• 2-D Pie: The standard, flat pie chart. It's the clearest and most common option.
• 3-D Pie: Adds depth to the chart. It can make your report look more dynamic but can sometimes make it harder to quickly compare slice sizes.
• Doughnut: A pie chart with a hole in the middle. We’ll discuss this more in the advanced tips.

For this example, click on the first option under 2-D Pie. Excel will instantly insert a basic budget pie chart directly onto your spreadsheet.

Customizing Your Budget Pie Chart for Clarity and Impact

The default chart Excel creates is a great start, but a few customizations can turn it from a basic visual into a professional and highly readable report. You'll primarily work with two contextual tabs that appear when your chart is selected: Chart Design and Format.

Simply click on your chart to reveal the customization options.

Give Your Chart a Meaningful Title

The default title is probably just "Amount." This isn't very descriptive. Click directly on the title text in the chart to edit it. Change it to something clear and specific, like "Monthly Budget Breakdown" or "Expense Distribution for May."

Graphed

Still Building Reports Manually?

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

Watch the Demo

Add and Format Data Labels

A pie chart without labels is just a colorful circle. You need to show what each slice represents. The best way to do this is with data labels.

1. Click on your chart to select it.
2. Click the green plus sign ("+"), which stands for Chart Elements, that appears on the right side of the chart.
3. Check the box next to Data Labels.
4. Click the small arrow next to "Data Labels" to see more placement options like "Center," "Inside End," or "Outside End." "Outside End" is often the cleanest look.

To really make your labels useful, you can add percentages:

1. With a data label selected, right-click and choose Format Data Labels... (or repeat steps 2 & 3 above and click "More Options...").
2. A formatting pane will appear on the right.
3. Under "Label Options," you'll see checkboxes. Check the boxes for Category Name and Percentage. You can uncheck "Value" to avoid clutter. This will display both the category and its percentage of the total budget for each slice (e.g., "Rent/Mortgage: 49%").

Change Colors and Styles

With your chart selected, click the Chart Design tab.

• Chart Styles: This is a gallery of pre-built design themes that include different colors, shadows, and label styles. Hover over them to see a live preview and pick one that you like.
• Change Colors: Click this button to choose from a variety of color palettes. This allows you to quickly change the look from a standard blue/orange theme to a monochromatic or more vibrant style.

For even more control, you can change the color of individual slices. Double-click on the slice you want to change (this will select only that piece). Then, right-click, choose Fill, and pick your desired color.

Explode a Slice to Draw Attention

Want to highlight your largest expense category or where you're putting your savings? Exploding a slice does this perfectly.

Click on the pie to select the whole chart. Then, click a second time on the specific slice you want to emphasize (e.g., the "Rent/Mortgage" slice). Once only that slice is selected, click and drag it slightly away from the center of the pie. This small separation immediately draws the viewer's eye to that category.

When to Avoid Using a Pie Chart for Your Budget

While pie charts are great for showing parts of a whole, they aren't always the right choice. Knowing their limitations will make your reporting more effective.

Avoid a pie chart when:

• You have too many categories. A pie chart with more than 6-7 slices starts to look like a cluttered, unreadable color wheel. If you have many small expense categories, consider grouping them into a single "Other" slice or using a Bar Chart instead.
• Category values are very similar. If "Utilities" is 9% and "Transportation" is 10%, it's almost impossible for the human eye to tell which slice is bigger. A Bar Chart makes these small comparisons much more obvious.
• You need to show changes over time. A pie chart is a snapshot of one period (e.g., one month). To compare your budget breakdown across several months, a Stacked Bar Chart or a Line Chart would be a much better tool for showing trends.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Bonus: Using a Doughnut Chart For Your Budget

A doughnut chart is essentially a pie chart with the center cut out. To create one, simply select Doughnut from the pie chart dropdown menu in the "Insert" tab.

The main advantage of a doughnut chart is that the empty space in the middle is perfect for displaying a key piece of information, such as your total monthly budget. You can do this by inserting a text box (Insert > Text Box) into the center and typing in the total. This adds a nice bit of context right inside your visual.

Final Thoughts

Mastering the budget pie chart in Excel is a fundamental skill for anyone looking to manage their finances, whether for personal budgeting or business reporting. By carefully structuring your data and using Excel's robust customization options, you can create a clear, communicative visual that instantly tells the story of where your resources are allocated.

While creating isolated charts in Excel is excellent for ad-hoc analysis, the process still requires manual data entry and regular updates. For businesses trying to get a complete view by connecting data from financial tools like QuickBooks, sales CRMs, and marketing platforms, this manual routine can consume hours every week. We built Graphed to automate that entire process. You can connect all your data sources in minutes and create live, interactive dashboards just by asking questions in plain English — no more downloading CSVs or wrestling with pivot tables, just real-time answers.