Hi everyone, I'm encountering some difficulties while trying to achieve a specific goal. I'm aiming to create a multiple doughnut chart with a fixed size. My scenario involves 9 variables and 6 group members. Essentially, I want to generate a chart where the circle is divided into the number of variables (resulting in 9 slices) and also divided along the radial axis by the number of members (yielding 6 sections in this case).
Initially, this task seems quite straightforward. However, I'm facing an issue when attempting to input the data. Specifically, I have binary data, and I would like to visualize it by painting the corresponding space in the chart if a member has a value of 1 for a specific variable. Otherwise, the space should remain blank.
Can anyone offer guidance on how to tackle this challenge? I would greatly appreciate any assistance or suggestions. Thank you!
So far I've tried to do it with a doughnut plot, the problem is that on the values of 0, the goughnut plot just ignores the value and divides the circle into 5.
Ideally I would have something like this: where here the variables will be 8 and the members will be 3.
desired.png
And I am achieving:
Captura de pantalla 2023-06-30 105044.png
Whenever I change the values to 0:
foto2.png
The data is below:
belbin.xlsx
Bookmarks