create a pie chart with percentages in excel

Read More: How to Create a 3D Pie Chart in Excel (with Easy Steps) After that, you will see the following result.Next, choose the type of pie chart that you want to insert. Then, click on the Insert Pie or Doughnut Chart icon in the Charts group from the Insert tab as shown below. As our budget table is formatted properly, now we can insert the budget pie chart.The dataset will be sorted accordingly after that. 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 Show Total in Excel Pie Chart (2 Effective Ways).How to Make a Household Budget in Excel (2 Smart Ways).Make a Wedding Budget in Excel (2 Suitable Methods).How to Create Square Pie Chart in Excel (2 Easy Ways).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.

Every chart in excel is created from a data table/range.

Steps to Make a Budget Pie Chart in Excelįollow the steps below to make a budget pie chart in excel quickly.

Create a pie chart with percentages in excel