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:
<tbody>
</tbody>
Any help would be greatly appreciated!
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:
Region | Region Total | Product A | Product B | Product C | Product D | Product E | Product F | Product G | Product H | Product I | Product J | Product K |
Europe | 1942 | 48 | 117 | 8 | 77 | 28 | 6 | 120 | 72 | 1069 | 397 | |
Middle East | 2571 | 80 | 102 | 2365 | 24 | |||||||
Africa | 382 | 30 | 43 | 66 | 243 | |||||||
Americas | 1236 | 1236 | ||||||||||
APAC | 3542 | 18 | 71 | 30 | 1808 | 1615 |
<tbody>
</tbody>
Any help would be greatly appreciated!