Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
sunburst charts

ResolvedVersion 365

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

Tue 7 Mar 2023: Automatically marked as resolved.

Excel tip:

Generating simple column charts

1.Select cell range containing data/figures
2. Press F11

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.08 secs.