A Sunburst chart is another type of hierarchical chart.
It's kind of like a mixture between a tree map and a pie chart. Before you insert a sunburst chart
what you need to do is to organize your data in groups. Notice here
division is all together.
I don't have productivity sitting in different sections.
It's all sitting together.
Once you have that set up, all you need to do is highlight the area where your data is. Go to insert, from
the hierarchy charts right here,
select sunburst.
The advantage of this is just like with a tree map.
Everything is sorted in descending order automatically.
So with a quick look, we can tell
game is the biggest division then productivity then utility. In the game division,
we have Australia first, North America, Europe, Asia, and then South America.
Even though the groupings look like of a similar size, the order is always in descending order. This
might be an advantage to using a treemap is that you can immediately tell what's the third biggest
here.
What I like about the treemap though is it looks more structured and I find that one easier to read.
You also have enough space to add in the data labels so let's just take a look at the options that we
have.
First of all, for the entire series I'm just going to click on it.
Press Control+1 to bring up the series options.
There are no options available here. There is nothing I can change for the series options.
What I can change is the color.
So if I just select this and select solid fill, it's going to apply one specific field color to everything.
Automatic gives each section its own color. But you can still go and change the color of each section.
If I click on this, I can go and select solid fill and change the color to a color of my choice.
Let's check the options we have for data labels. So just select the labels, go to label options.
I have the option to add a value or a series name. If I want to see the numbers just put a tick mark
beside value and I see the numbers here.
But because these are too small I can hardly read the label or the value. Let's just expand this.
Now we can see the values better for some of these sections.
Sunburst chart is also one of these newer charts that got introduced. It's not as flexible as the
standard Excel chart.
Again, the title is not something we can connect to a cell value. We have to manually type it in.
But the advantage is that it does all the sorting and organizing for you.
So check this out.
Europe is the biggest region in the productivity division.
So let's change that number.
Let's just majorly reduce it to a small number.
Everything got shifted. So the entire productivity division became third place and Europe is this tiny
little space in our Sunburst chart.
That's how easy it is to create a Sunburst chart.
Now let's take a look at creating a pie chart.
I'm personally not a big fan of pie charts. I find there are other chart types like column chart or
bar charts that are more transparent. But I find pie chart to be okay
if you have just a few categories you're analyzing.
In this case I just have three divisions.
It's fine to show that in a pie chart as well.
Management also happens to be a fan of pie charts and they're also super easy to create.
So if we were going to create a pie chart out of this, all we have to do is highlight the data set, go
to insert and click on the first pie we see here. But let's not leave it like this.
Let's make this much easier to read. Because right now we don't have any numbers and it's difficult to
tell what belongs to what we have. So look at the color here, we have to go there and check the color
here then check back and forth.
First off, let's add data labels to these. Just right mouse click, add data labels.
This automatically puts in the numbers but let's add more.
Let's also add the categories.
Just highlight the labels press Control+1 to bring up the format data labels options. Under the
label contains let's activate the category name.
This makes it much easier to read.
I'm just going to go and change the color to white.
If you want to have the labels get a unified look, what you can do is for the separator option to show
the second label as a new line. Instead of a comma we have a new line so the number is below the category
name.
Once we have the labels activated we don't need the legends.
I can remove that. Now for the series options as a whole.
We have two options.
We can decide on the angle of the first slice.
If I just increase this notice that the angle of the first one is shifting. I'm just going to go
with zero.
We can also decide on the pie explosion.
The higher I bring this, the smaller and more apart each of the piece of the pie becomes. One thing
to note is that the pie chart is one of Excel standard charts. It is more flexible than the newer
charts introduced. You can connect the title of the chart to a cell value.
Now let's take a look at creating a doughnut chart.
Doughnut charts are pie charts that have a hole in the middle.
Instead of creating a doughnut chart from scratch, I'm just going to take this pie chart and change
the chart type to a doughnut chart.
Now when I click inside the series here.
I have the option change series chart type. When I click outside in my plot area.
I have change chart type. I'm going to go with this option.
I want a doughnut chart. The doughnut is sitting in the pie chart options.
It's the last one, select it and click on ok.
I have a pie chart with a hole in it.
Let's just take a look at the series options here.
I have one additional option that I didn't have with a pie chart.
What's that?
It's the hole size. So I can make the hole a lot bigger or a lot smaller. So if I close the hole I get
a pie chart.
Let's go with 40 percent.
That's how you can create a doughnut chart in Excel.