The Pie of Pie Chart in Excel Demystified

Pie charts are used to display data points as a percentage of the whole value. Excel provides a few different variations of pie chart to choose from. One with a difference is the pie of pie chart.

The pie of pie chart is used to display the smaller values of a pie chart in a secondary pie to make them more visible.

Take the pie chart below for instance. The loyalty coupon, offline and referrals values make up such a small percentage of the pie chart that they are difficult to read and understand.

Let’s see the same data set using a pie of pie chart. The primary pie displays the smaller values making up 5% of the whole value. These values are then displayed in a secondary pie giving much more attention to the detail.

The smaller data points retain their percentages as a contribution to the whole and lines are used to visualise the enhanced segment easily.