How can I make a multy-level pie/doughnut chart? | Excel forum

Well done Chris,

Let me know if you get problems doing it.


Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Hi Chris,


Please have a look at my example (see attachment).

You can only change the angle and "explode" the outer part of the chart. If you want the chart to look like it is "exploded" (white gabs between the parts) you can add white shape outlines and set the weight.

A walk around what you want is to create three charts and align them on top of each other (have a look at my second chart in my example). If you do this you can change the angle for each of them and also "explode" each of them.

I have used spinners (form controls) so you can change the values with the mouse. I use a formula to make sure that what ever value you change the sum of the value shown in the chart = 360 (the circle's 360 degrees).


Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector