Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Sunburst Charts
Resolved · Low Priority · Version 365
Max has attended:
Excel Advanced - For Power Users course
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?
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:Recently used file listUnder the File menu, you may find a list of files at the bottom of the menu. These files represent the most recently used Excel spreadsheets. This file list provides a quick way for you to access your files. |
We'll call during UK business hours
Server loaded in 0.08 secs.