How to Make a Budget Pie Chart in Excel (with Easy Steps)

Get FREE Advanced Excel Exercises with Solutions!

This article illustrates how to make a budget pie chart in excel.  A pie chart is a circular chart. It is a statistical graphic divided into slices to highlight the numerical proportions of a dataset. A budget pie chart illustrates the proportion of expenses of each budget category compared to the total budget. Have a quick look through the article to learn how to make a budget pie chart in excel.


Download Practice Workbook

You can download the practice workbook from the download button below.


Steps to Make a Budget Pie Chart in Excel

Follow the steps below to make a budget pie chart in excel quickly.

📌 Step 1: Set Budget Categories

  • Every chart in excel is created from a data table/range. It is no exception for a budget pie chart.
  • The data source for a budget pie chart should contain the budget categories and related expenses.
  • So, enter the budget categories first to make your budget table. Your budget may include rent or housing, transportation, travel expenses, vehicle insurance, food, groceries, utility bills, mobile phone bills, childcare, school costs, pet food and care, pet insurance, clothing and personal care, life insurance, health insurance, homeowners insurance, entertainment, student loans, credit card debt, emergency fund, etc.
  • Here, I have listed a few categories in cells B5:B10 for example.

Read More: How to Do Budgeting and Forecasting in Excel (2 Suitable Ways)


📌 Step 2: Enter Budget Amounts

  • Next, you need to enter the expenses related to each budget category. Here, I have entered the corresponding amounts in cells C5:C10.


Similar Readings


📌 Step 3: Format Budget Table

  • We can use the above data table to make the budget pie chart. But, it is better to sort the amounts in the dataset to make the budget pie chart more presentable.
  • Now, select any cell in the dataset containing the amounts. Then, select Sort & Filter in the Editing group from the Home tab as shown below. Next, click on Largest to Smallest or Smallest to Largest. The dataset will be sorted accordingly after that.


📌 Step 4: Insert Pie Chart

  • As our budget table is formatted properly, now we can insert the budget pie chart.
  • Now, select a cell in the dataset. Then, click on the Insert Pie or Doughnut Chart icon in the Charts group from the Insert tab as shown below. Next, choose the type of pie chart that you want to insert. Here we will insert a 2-D Pie chart.

insert a budget pie chart in excel

  • After that, you will see the following result.

budget pie chart in excel

Read More: How to Create a 3D Pie Chart in Excel (with Easy Steps)


📌 Step 5: Edit Budget Pie Chart

  • Now you need to edit the pie chart to make it more presentable. First, click on the chart title (Amount) and give a proper title (for say, Monthly Budget).

  • Next, click on the Chart Elements icon (+) in the upper-right corner. You can show/hide the categories using the Legend Click on Right to show the categories at the right of the chart and so on. You can also click on the categories to make them bold or increase the font size.

  • Now, check the Data Labels checkbox to show the amounts on the chart. If you want to show the percentage only, then select More Options.

  • After that, you will see the Format Data Labels Now, check the Percentage checkbox first and then uncheck the Value checkbox.

  • After that, only the percentages of the amounts will be shown.

Read More: How to Make Pie Chart in Excel with Subcategories (2 Quick Methods)


📌 Step 6: Design Budget Pie Chart

  • You can choose from different designs and colors for your budget pie chart. Click on the chart to access the Chart Design tab to do that. You can also format the chart from the Format tab.


📌 Step 7: Finalise Budget Pie Chart

  • After choosing the proper design and colors, the final budget pie chart may look like the following.

how to make a budget pie chart in excel

Read More: How to Change Pie Chart Colors in Excel (4 Easy Ways)


Things to Remember

  • You must select a cell in the dataset or the entire dataset before inserting the pie chart. Excel should detect the data range automatically. Otherwise, you need to enter the data range manually.
  • You need to click on the pie chart to access the editing options.

Conclusion

Now you know how to make a budget pie chart in excel. Do you have further queries or suggestions? Please let us know in the comment section below. You can also visit our ExcelDemy blog to explore more about excel. Stay with us and keep learning.


Related Articles

Md. Shamim Reza

Md. Shamim Reza

Hello there! This is Md. Shamim Reza. Working as an Excel & VBA Content Developer at ExcelDemy. We try to find simple & easy solutions to the problems that Excel users face every day. Our goal is to gather knowledge, find innovative solutions through them and make those solutions available for everybody. Stay with us & keep learning.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo