sunburst charts

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

TrustPilot

starstarstarstarstar Excellent

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Sunburst Charts

Sunburst Charts

resolvedResolved · Low Priority · Version 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:

Recently used file list

Under 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.

You can disable the file list feature of Excel. This is done by

1. Choose Tools > Options menu. You will see the Options dialog box.
2. Ensure the General tab is selected.
3. Make sure the Recently Used File List check box is cleared.
4. Click on OK.

View all Excel hints and tips


Server loaded in 0.08 secs.