you can change the way the pie has been split by clicking the Split series by option as shown below. Then again, keep in mind that a pie chart with more than three slices is not good data visualisation, anyway. You may want to create a copy of the source data, sort it, then build the chart off that. Right click on any area of the Pie chart and Chose Format Data series option. The slice order depends on the order of the data. Select the data, click Insert tab > chose pie chart ribbon >Pie of pie chart as shown belowįrom the chart styles chose the style of charts that suits our representation. Lets see how to create Pie of Pie chart in Excel.

In that case we use Pie of Pie chart which Projects those values which is less than the threshold as a separate pie chart.ĭata that we use to demonstrate Pie of Pie chart in Excel is shown below (number of units produced across months). When there is too much of categories with very less percentage distribution then the pie chart becomes quite messy. When we need to represent the percentage distribution across categories we generally use Pie chart.

In this tutorial we will learn how to create pie of pie chart in Excel and Bar of Pie chart in Excel.

How make a pie chart in excel