Double Donut - Need Help!!!

[ExcelNovice92]

Good afternoon all,

I'm struggling with a double donut chart. I know exactly how I want it to look in my head, but when I create it on Excel, it doesn't look the same!

I have a number of products, in a number of regions.

For instance:
Product A has 10 in Region 1, 10 in Region 2 and 0 in Region 3.
Product B has 0 in Region 1, 5 in Region 2 and 10 in Region 3.
Product C has 15 in Region 1, 10 in Region 2 and 10 in Region 3.

Totals:
Region 1 - 25
Region 2 - 25
Region 3 - 20

So that would make up a donut split into 3 pieces, split roughly evenly. No problem!

The problem occurs when I then want to breakdown each region. So by having a donut within that with more breaks in it.
Region 1 would then be split into 2 pieces, Region 2 split into 3, and Region 3 split into 2 also.

I can't get that second donut!


The table I'm using:
[TABLE="width: 861"]
<tbody>[TR]
[TD]Region[/TD]
[TD]Region Total[/TD]
[TD]Product A[/TD]
[TD]Product B[/TD]
[TD]Product C[/TD]
[TD]Product D[/TD]
[TD]Product E[/TD]
[TD]Product F[/TD]
[TD]Product G[/TD]
[TD]Product H[/TD]
[TD]Product I[/TD]
[TD]Product J[/TD]
[TD]Product K[/TD]
[/TR]
[TR]
[TD]Europe[/TD]
[TD="align: right"]1942[/TD]
[TD="align: right"]48[/TD]
[TD="align: right"]117[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]77[/TD]
[TD="align: right"]28[/TD]
[TD][/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]120[/TD]
[TD="align: right"]72[/TD]
[TD="align: right"]1069[/TD]
[TD="align: right"]397[/TD]
[/TR]
[TR]
[TD]Middle East[/TD]
[TD="align: right"]2571[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]80[/TD]
[TD][/TD]
[TD="align: right"]102[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]2365[/TD]
[TD="align: right"]24[/TD]
[/TR]
[TR]
[TD]Africa[/TD]
[TD="align: right"]382[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]30[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]43[/TD]
[TD="align: right"]66[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]243[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Americas[/TD]
[TD="align: right"]1236[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1236[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]APAC[/TD]
[TD="align: right"]3542[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]71[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]30[/TD]
[TD][/TD]
[TD="align: right"]1808[/TD]
[TD="align: right"]1615[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Any help would be greatly appreciated!

 

[Dave Paradi]

If I understand correctly, you are trying to create what I would refer to as a donut breakdown graph like this.

There can only be two data series so that you only have two donuts. You can see how the data series are set up in the image. The data labels have to all be manually positioned and the segments individually selected and the fill color changed to get the graph you see in the image. It is a lot of manual work.

With the data you listed, this type of graph may be very complex and crowded unless it is a very large donut to fit all the segments and labels (if you want labels).

Hope this helps.