Next, click on Largest to Smallest or Smallest to Largest. Then, select Sort & Filter in the Editing group from the Home tab as shown below. Now, select any cell in the dataset containing the amounts.But, it is better to sort the amounts in the dataset to make the budget pie chart more presentable. We can use the above data table to make the budget pie chart.How to Make a Household Budget in Excel (2 Smart Ways).How to Make a Wedding Budget in Excel (2 Suitable Methods).How to Make a Family Budget in Excel (2 Effective Ways).Here, I have entered the corresponding amounts in cells C5:C10.
Next, you need to enter the expenses related to each budget category.Read more: How to Do Budgeting and Forecasting in Excel (2 Suitable Ways) Here, I have listed a few categories in cells B5:B10 for example.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. So, enter the budget categories first to make your budget table.The data source for a budget pie chart should contain the budget categories and related expenses.It is no exception for a budget pie chart.