+ Reply to Thread
Results 1 to 3 of 3

Multiple doughnut chart with fixed sizes

  1. #1
    Registered User
    Join Date
    06-30-2023
    Location
    Denmark
    MS-Off Ver
    2305
    Posts
    2

    Multiple doughnut chart with fixed sizes

    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
    Last edited by alexabades; 06-30-2023 at 07:25 AM. Reason: Adding excel sheet

  2. #2
    Registered User
    Join Date
    08-03-2012
    Location
    Manchester, England
    MS-Off Ver
    Office 365
    Posts
    16

    Re: Multiple doughnut chart with fixed sizes

    It would make life a lot easier for all concerned if you could attach a spreadsheet containing the data, in the format you will be using.

  3. #3
    Registered User
    Join Date
    06-30-2023
    Location
    Denmark
    MS-Off Ver
    2305
    Posts
    2

    Re: Multiple doughnut chart with fixed sizes

    My bad, you're completely right. I just upload them

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Help on doughnut pie chart
    By theprincesunil in forum Excel General
    Replies: 3
    Last Post: 05-22-2017, 02:17 PM
  2. Doughnut Pie chart
    By colegerald38 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-06-2016, 04:23 PM
  3. Doughnut Chart Labels
    By Shleifer in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-24-2014, 04:02 AM
  4. Doughnut-pie combine chart
    By [email protected] in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 03-26-2014, 07:49 AM
  5. Doughnut chart 2 rings help
    By jmoslund in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-02-2011, 06:55 AM
  6. Doughnut chart
    By TomBP in forum Access Tables & Databases
    Replies: 8
    Last Post: 02-19-2011, 09:46 AM
  7. Multiple Font Sizes In A Chart Title
    By VPI63 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-28-2010, 11:02 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1