Hi everyone. I'm trying to create a doughnut in doughnut chart(or circle in circle/pie in pie) and this is what I need.
So Ring 1 and Ring 2 are from two different Variables but share 9 common segments (TargetGroupsName). I was told to have them this with each circle with the initials of the segment and percentage as drawn.
Here is a simple data of my my data looks like
I'm also checked out these forums but they make no sense. I do not get how the got their measure variables
How to create a doughnut chart inside a doughnut chart?null
Please help
On the Data tab on the Excel workbook, you'd just need to change the numbers in the Value field to your actual values. And, of course, you'd want to change the Component field to be whatever you're actually showing. You can add other columns in the Data tab, if you like as well.
Attached is a version of the data and the workbook with non-equal values.