Double Donut - Need Help!!!

ExcelNovice92

New Member
Joined
Jul 4, 2019
Messages
1
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:
RegionRegion TotalProduct AProduct BProduct CProduct DProduct EProduct FProduct GProduct HProduct IProduct JProduct K
Europe194248117877286120721069397
Middle East257180102236524
Africa382304366243
Americas12361236
APAC354218713018081615

<tbody>
</tbody>

Any help would be greatly appreciated!
 

Dave Paradi

New Member
Joined
Jun 24, 2019
Messages
31
Office Version
365
Platform
Windows
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.
 

Forum statistics

Threads
1,086,074
Messages
5,387,666
Members
402,072
Latest member
Nauef

Some videos you may like

This Week's Hot Topics

Top