Md. Shamim Reza
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
- How to Make a Family Budget in Excel (2 Effective Ways)
- How to Create Square Pie Chart in Excel (2 Easy Ways)
- Make a Wedding Budget in Excel (2 Suitable Methods)
- How to Make a Household Budget in Excel (2 Smart Ways)
- How to Show Total in Excel Pie Chart (2 Effective Ways)
📌 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.
- After that, you will see the following result.
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.
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.
