It will look good if we can display less than 10 categories, otherwise it will become not readable in the pie chart. Select the data and go to Insert > Insert Pie Chart > select chart type. Click on the drop-down menu of the pie chart from the list of the charts. Moreover we have to choose the categories in such a way that the total of categories should we displayed as a percentage of 100. Follow the below steps to create a Pie of Pie chart: 1. Nay negative value if used will be displayed as it positive part. This should include what is being measured, and how much of it there is. Click Insert tab, Pie button then choose from the selection of pie chart types: Pie, Exploded Pie, Pie of pie, Bar of pie, or 3D pie chart. From your Excel worksheet, highlight the data you want to appear in your pie. First, we select the data we want to graph. 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. Just like any chart, we can easily create a pie chart in Excel version 2013, 2010 or lower.
Sort the sales data in descending order of sales. This is called Pie of Pie chart in Excel.
In this article we will try to learn how to create the Pie of the Pie chart. What we can do is, consolidate all low sales customers into 1 single slice, and then split that slice into another pie chart to explain the data better. How to Create Pie of Pie Chart in Excel Details