We can see this percentage by hovering over a wedge in the chart. Since we have 20 pears, the orange wedge is 20/50=40% of the whole pie chart. Since our list of fruits add up to 50, the wedges are the percentage calculated as the number divided by 50. Notice that the pie wedges are not a representation of the numbers in the column, but the percentage of the total. You can also edit the appearance of the chart using the menu bar at the top or by double-clicking on different parts of the chart. You can adjust the size by pushing and pulling on the sides of the chart. Then select PIEĮxcel will automatically create a pie chart for you. Step 3: In Excel, go to INSERT in the menu.

If you want to have the labels on the chart, you need to highlight the labels of the data as well. Notice that the total percentage adds up to 100%. Here is a list of the favorite color percentages of some population of people. Notice that they add up to a total of 50. Here is a list of different fruits and the number of each.

The pie chart will be a representation of the percentages of the data total.

It will look good if we can display less than 10 categories, otherwise it will become not readable in the pie chart.Video Source (04:11 mins) | Transcript Step 1: Have a list of data in Excel Moreover we have to choose the categories in such a way that the total of categories should we displayed as a percentage of 100. Nay negative value if used will be displayed as it positive part. Pie chart is also called as a circle chart and the data is represented in the a circle which resembles slices of pie.īut we have a limitation in pie charts, unlike other charts like column and line chart we can only use single data series in a pie chart.Īlso we cannot display any negative value of a zero value in a pie chart which is another limitation. In this article we will try to learn how to create the Pie of the Pie chart. How to Create Pie of Pie Chart in Excel Details

Make a pie chart in excel