8.4 Pie and Doughnut Charts
Use for one series, few slices (≤ 5), when the message is "share of a whole". Otherwise use a bar chart.
Worked example – payment mode share (fictional, one month, Pune): UPI 68%, Card 14%, Cash on Delivery 12%, Wallet 6%. A doughnut with the total in the centre (a text box linked to a cell: select the text box, type = in the formula bar and click the total cell).
Steps in Excel
- Select the payment modes and values › Insert › Charts › Pie or Doughnut › Doughnut.
- Ctrl + 1 on the ring › Doughnut Hole Size 60%.
-
- › Data Labels › More Options › tick Category Name and Percentage, untick Value.
- Sort slices largest first; start the first slice at 0° (Angle of first slice).
Ravindra Bagale's Tip
Pie chart madhe 10-12 slices takne hi khup students chi aavdati chuk aahe – ekahi slice vachta yet nahi. 5 peksha jast categories asle tar lahan categories "Others" madhe ghala kiwa bar chart vapra. Ani pie chart madhe 3D kadhich nako.
Practice task
Build a doughnut chart of order share by status (Delivered, Cancelled, Returned) with percentage labels and the total order count in the centre.