The human eye has trouble comparing the relative size of slices in a pie chart, and this problem is compounded with the pie of pie variety. Pie of pie charts should be avoided when there are many categories, or when categories do not total 100%. When configuring a Pie of Pie chart, Excel provides a setting that moves the smallest n slices of the pie to another smaller pie, where n can be adjusted to suit the data. Don't forget to like, comment and subscribe because it's all free Watch more video.

Select any formatting option from the list. How to Make a Pie Chart in ExcelThank for watching this video tutorial. Hover the cursor on the Data Labels option. In the Design tab, click on the Add Chart Element (it’s in the Chart Layouts group). Choose your pie chart type in the drop-down. This will make the Design tab available in the ribbon. Then go to the Insert tab, and click on the Pie Chart icon in the Charts group. The Pie of Pie Chart provides a way to add additional categories to a pie chart without generating a pie chart too complex to read. Here are the steps to format the data label from the Design tab: Select the chart. There are several formats to choose from. Pie charts work best to display data with a small number of categories (2-5). To create a Pie chart in Excel, select your data, then click on the Insert tab, then Pie. Pie charts are meant to express a 'part to whole' relationship, where all pieces together represent 100%. The Pie of Pie Chart is a built-in chart type in Excel.

How do i make a pie chart in excel