Skip to main content

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.

Doughnut in doughnut Chart Help

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

Ring+data.PNG

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

16 answers
  1. Aug 8, 2018, 6:49 PM

    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.

     

    On the Data tab on the Excel workbook, you'd just need to change the numbers in the Value field to your actual values.

0/9000