+ Reply to Thread
Results 1 to 11 of 11

Sunburst chart proportion

  1. #1
    Registered User
    Join Date
    11-07-2019
    Location
    Romania
    MS-Off Ver
    2016
    Posts
    5

    Angry Sunburst chart proportion

    Hello,

    I want to make a pie like in the image attached.

    I try to do this using sunburst chart type in excel but I can't make it looks like the chart in the report present on the link above.

    Can you tell me please if I can do that chart with excel charts?

    Thank you!
    Attached Images Attached Images
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    11-05-2019
    Location
    Tiki Island, TX
    MS-Off Ver
    Office 365
    Posts
    168

    Re: Sunburst chart proportion

    Are you trying to get the map part or the colored funnel by decreasing value?

  3. #3
    Registered User
    Join Date
    11-07-2019
    Location
    Romania
    MS-Off Ver
    2016
    Posts
    5

    Re: Sunburst chart proportion

    Hello Mr DavidBowman.
    The map will not be a probleme because I will make in other program.....

    Yes, the colored funnel by decreasing value is my problem. I can't make look like in image above. I can't make that proportion scale look like that.
    Can you tell me if I can make with excel chart this type of proportion and if can look like that?

    Thank you,
    Best recards.
    Catalin S

  4. #4
    Forum Contributor
    Join Date
    11-05-2019
    Location
    Tiki Island, TX
    MS-Off Ver
    Office 365
    Posts
    168

    Re: Sunburst chart proportion

    Unfortunately that is the part I can't help with.

  5. #5
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,431

    Re: Sunburst chart proportion

    Starburst will not do this as each layer is the same thickness. It the segments within a band that changes not the thickness/height.

    In the attached are 2 examples you you might be able to use.
    Sheet 1 has a filled radar. The stacks are pointed wedges but the distance from center is correct.

    Sheet 2 has a multi layer donut. The stacks are more like your example but the distance from center is in bands.
    The example is 10% bands. In order to get the accuracy of 1% you will need to expand the number of layers. You also need to include an addition series for
    each country in order to display nothing when the value does not equal the same as the outer layer. With out the padding all the other countries on that layer will be out of sync.

    There is a small bit of code to format the points within each series to be white.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  6. #6
    Registered User
    Join Date
    11-07-2019
    Location
    Romania
    MS-Off Ver
    2016
    Posts
    5

    Re: Sunburst chart proportion

    In the end I have the results that I want.
    So I thank you Mr. Andy Pope.

    One last question, can you tell me how can I modify the macro code so that I can edit border color of series or layer?

  7. #7
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,431

    Re: Sunburst chart proportion

    change red and white colours to whatever rgb value you require

    Please Login or Register  to view this content.

  8. #8
    Registered User
    Join Date
    11-07-2019
    Location
    Romania
    MS-Off Ver
    2016
    Posts
    5

    Re: Sunburst chart proportion

    Now it look's very nice.

    Now, only problem is the loading of 100 columns that represents 100%.
    Last edited by CatalinS; 11-14-2019 at 08:03 AM.

  9. #9
    Registered User
    Join Date
    11-07-2019
    Location
    Romania
    MS-Off Ver
    2016
    Posts
    5

    Re: Sunburst chart proportion

    The final result ,is just what I want.
    Thank you for your help!

    Best regards
    Attached Images Attached Images

  10. #10
    Registered User
    Join Date
    02-14-2012
    Location
    London, England
    MS-Off Ver
    Excel 2003 & 2010
    Posts
    7

    Re: Sunburst chart proportion

    Hi CatalinS,

    Any chance you can share your Excel file? I am trying to do something similar and it is driving me crazy!

    Thanks

    Bax

  11. #11
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,535

    Re: Sunburst chart proportion

    Administrative Note:

    We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

    Please see Forum Rule #4 about hijacking and start a new thread for your query.

    If you are not familiar with how to start a new thread see the FAQ: How to start a new thread

    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. Sunburst Chart Color Issue
    By cworthington04 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 08-13-2019, 03:17 PM
  2. Sunburst - Dynamic Range
    By ionelz in forum Excel General
    Replies: 2
    Last Post: 01-24-2019, 04:02 AM
  3. Sunburst Chart Excel 2016
    By whatsherface1990 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-08-2018, 07:06 PM
  4. How to hide rows without making Sunburst chart to disappear
    By Ravichandran Kannapp in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 11-14-2017, 05:40 PM
  5. [SOLVED] How to reverse Sunburst chart Clockways
    By sovietchild in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 07-16-2016, 04:18 AM
  6. Replies: 0
    Last Post: 02-28-2012, 09:47 AM
  7. changing proportion of chart and data table
    By Dawn Parks in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 01-05-2005, 10:06 PM

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