Sunburst Charts are one of the many new Charts
available in Excel 2016 and later versions.
The sunburst chart is ideal for displaying
hierarchical data.
Each level of the hierarchy is represented
by one ring or circle with the innermost circle
as the top of the hierarchy.
A sunburst chart without any hierarchical
data (one level of categories), looks similar
to a doughnut chart.
However, a sunburst chart with multiple levels
of categories shows how the outer rings relate
to the inner rings.
A sunburst chart is more advanced than the
doughnut chart as it not only shows the sizes
but also shows the relationships in the hierarchy.
The sunburst chart is most effective at showing
how one ring is broken into its contributing
pieces, while another type of hierarchical
chart, the treemap chart, is ideal for comparing
relative sizes.
So let’s dive in:
Highlight your table , from A1 to D23 and
from Insert Tab , Insert Hierarchy Chart Button
, select Sunburst.
Move it somewhere there and make it bigger.
Let’s take a look at the chart.
In the innermost ring we marked with blue
color all the sales from January.
From the chart containing only the raw data
we could not have seen right away the fact
that January Sales take up almost half of
all the income.
Amongst other things this is one of the advantages
of the data visualization.
The second ring is the subcategory level.
Within the category of January, Week 2 was
the most profitable.
From the plus icon you can edit the Chart
elements: Chart Title, Data Labels, or Legend.
You can further customize the look and feel
of your sunburst Chart, by clicking the paintbrush
to change the chart's design, such as Style
and Color.
Select this style.
Also delete the legend, the chart title and
remove the gridlines.
If you need more advanced modifications of
the sunburst , you can use the 2 tabs Chart
design and Format.
For example , from this button you can apply
a quick layout and form this you can change
the colors.
I hope you found this tutorial useful and
I want to thank you for watching it.
Hit the thumbs up if you enjoyed it.
If you want to learn more about excel’s
basic and advanced charts check out my Udemy
course.
Don’t forget to subscribe to get updates
and I’ll see you in the next video.
