Max has attended:
Excel Advanced - For Power Users course
Sunburst Charts
How do I make an inverted / reverse sunburst chart so that it starts with many items o the inside, merging on the outside to make broader categories?
RE: Sunburst Charts
Hi max
Thank you for using the forum to ask a question.
Can you share what data you are trying to turn in to a Sunburt diagram?
They are designed for hierarchical data, so progressively getting smaller increments on each ring. The logic doesn't flow that they would get decrease as you move through the hierarchy so what you are asking for currently outside the limits of the Chart type.
Please review this information for an overview of what they do
https://support.microsoft.com/en-us/office/create-a-sunburst-chart-in-office-4a127977-62cd-4c11-b8c7-65b84a358e0c #:~:text=The%20sunburst%20chart%20is%20ideal,similar%20to%20a%20doughnut%20chart.
Might I suggest you try a Doughnut Chart?
Create it with Series 1
Then "Add Series 2"
This will created a Double Doughnut Chart which isn't constrained to the Sunburst chart limitations
Kind regards
Richard
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector