![]() After that, only the percentages of the amounts will be shown.After that, you will see the Format Data Labels Now, check the Percentage checkbox first and then uncheck the Value checkbox.If you want to show the percentage only, then select More Options. Now, check the Data Labels checkbox to show the amounts on the chart.You can also click on the categories to make them bold or increase the font size. 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. Next, click on the Chart Elements icon ( +) in the upper-right corner.First, click on the chart title (Amount) and give a proper title (for say, Monthly Budget). Now you need to edit the pie chart to make it more presentable.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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |