![]() Otherwise, you need to enter the data range manually. Excel should detect the data range automatically. ![]() You must select a cell in the dataset or the entire dataset before inserting the pie chart.Read More: How to Create a 3D Pie Chart in Excel After choosing the proper design and colors, the final budget pie chart may look like the following.You can also format the chart in the Format tab. Click on the chart to access the Chart Design tab to do that. You can choose from different designs and colors for your budget pie chart.Read More: How to Make Multiple Pie Charts from One Table 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 Make a Pie Chart in Excel ![]() 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. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |