1
00:00:01,500 --> 00:00:05,020
A Sunburst chart is another type of hierarchical chart.

2
00:00:05,110 --> 00:00:11,290
It's kind of like a mixture between a tree map and a pie chart. Before you insert a sunburst chart

3
00:00:11,290 --> 00:00:16,059
what you need to do is to organize your data in groups. Notice here

4
00:00:16,059 --> 00:00:18,400
division is all together.

5
00:00:18,430 --> 00:00:22,060
I don't have productivity sitting in different sections.

6
00:00:22,060 --> 00:00:23,670
It's all sitting together.

7
00:00:23,710 --> 00:00:31,360
Once you have that set up, all you need to do is highlight the area where your data is. Go to insert, from

8
00:00:31,360 --> 00:00:33,480
the hierarchy charts right here,

9
00:00:33,610 --> 00:00:35,650
select sunburst.

10
00:00:35,770 --> 00:00:38,900
The advantage of this is just like with a tree map.

11
00:00:39,040 --> 00:00:42,430
Everything is sorted in descending order automatically.

12
00:00:42,460 --> 00:00:44,700
So with a quick look, we can tell

13
00:00:44,710 --> 00:00:50,230
game is the biggest division then productivity then utility. In the game division,

14
00:00:50,320 --> 00:00:55,150
we have Australia first, North America, Europe, Asia, and then South America.

15
00:00:55,150 --> 00:01:02,500
Even though the groupings look like of a similar size, the order is always in descending order. This

16
00:01:02,500 --> 00:01:08,860
might be an advantage to using a treemap is that you can immediately tell what's the third biggest

17
00:01:08,860 --> 00:01:09,610
here.

18
00:01:09,640 --> 00:01:17,300
What I like about the treemap though is it looks more structured and I find that one easier to read.

19
00:01:17,320 --> 00:01:22,840
You also have enough space to add in the data labels so let's just take a look at the options that we

20
00:01:22,840 --> 00:01:23,510
have.

21
00:01:23,590 --> 00:01:26,920
First of all, for the entire series I'm just going to click on it.

22
00:01:26,920 --> 00:01:30,020
Press Control+1 to bring up the series options.

23
00:01:30,190 --> 00:01:35,950
There are no options available here. There is nothing I can change for the series options.

24
00:01:35,980 --> 00:01:38,350
What I can change is the color.

25
00:01:38,380 --> 00:01:46,390
So if I just select this and select solid fill, it's going to apply one specific field color to everything.

26
00:01:47,020 --> 00:01:54,390
Automatic gives each section its own color. But you can still go and change the color of each section.

27
00:01:54,390 --> 00:02:02,200
If I click on this, I can go and select solid fill and change the color to a color of my choice.

28
00:02:02,200 --> 00:02:08,220
Let's check the options we have for data labels. So just select the labels, go to label options.

29
00:02:08,259 --> 00:02:15,370
I have the option to add a value or a series name. If I want to see the numbers just put a tick mark

30
00:02:15,400 --> 00:02:19,050
beside value and I see the numbers here.

31
00:02:19,120 --> 00:02:27,610
But because these are too small I can hardly read the label or the value. Let's just expand this.

32
00:02:27,610 --> 00:02:31,760
Now we can see the values better for some of these sections.

33
00:02:31,770 --> 00:02:38,000
Sunburst chart is also one of these newer charts that got introduced. It's not as flexible as the

34
00:02:38,000 --> 00:02:39,690
standard Excel chart.

35
00:02:39,700 --> 00:02:46,900
Again, the title is not something we can connect to a cell value. We have to manually type it in.

36
00:02:46,900 --> 00:02:51,680
But the advantage is that it does all the sorting and organizing for you.

37
00:02:51,790 --> 00:02:53,110
So check this out.

38
00:02:53,110 --> 00:02:56,770
Europe is the biggest region in the productivity division.

39
00:02:56,770 --> 00:02:58,020
So let's change that number.

40
00:02:58,020 --> 00:03:02,170
Let's just majorly reduce it to a small number.

41
00:03:02,560 --> 00:03:08,470
Everything got shifted. So the entire productivity division became third place and Europe is this tiny

42
00:03:08,470 --> 00:03:11,340
little space in our Sunburst chart.

43
00:03:11,350 --> 00:03:15,950
That's how easy it is to create a Sunburst chart.

44
00:03:16,270 --> 00:03:19,410
Now let's take a look at creating a pie chart.

45
00:03:19,420 --> 00:03:25,570
I'm personally not a big fan of pie charts. I find there are other chart types like column chart or

46
00:03:25,570 --> 00:03:30,490
bar charts that are more transparent. But I find pie chart to be okay

47
00:03:30,490 --> 00:03:33,730
if you have just a few categories you're analyzing.

48
00:03:33,730 --> 00:03:36,760
In this case I just have three divisions.

49
00:03:36,760 --> 00:03:39,430
It's fine to show that in a pie chart as well.

50
00:03:39,430 --> 00:03:45,300
Management also happens to be a fan of pie charts and they're also super easy to create.

51
00:03:45,340 --> 00:03:50,650
So if we were going to create a pie chart out of this, all we have to do is highlight the data set, go

52
00:03:50,650 --> 00:03:57,430
to insert and click on the first pie we see here. But let's not leave it like this.

53
00:03:57,430 --> 00:04:02,650
Let's make this much easier to read. Because right now we don't have any numbers and it's difficult to

54
00:04:02,650 --> 00:04:06,760
tell what belongs to what we have. So look at the color here, we have to go there and check the color

55
00:04:06,760 --> 00:04:09,670
here then check back and forth.

56
00:04:09,700 --> 00:04:15,850
First off, let's add data labels to these. Just right mouse click, add data labels.

57
00:04:15,850 --> 00:04:19,839
This automatically puts in the numbers but let's add more.

58
00:04:19,899 --> 00:04:22,079
Let's also add the categories.

59
00:04:22,079 --> 00:04:28,930
Just highlight the labels press Control+1 to bring up the format data labels options. Under the

60
00:04:28,930 --> 00:04:32,800
label contains let's activate the category name.

61
00:04:32,950 --> 00:04:35,780
This makes it much easier to read.

62
00:04:35,830 --> 00:04:39,560
I'm just going to go and change the color to white.

63
00:04:39,760 --> 00:04:46,960
If you want to have the labels get a unified look, what you can do is for the separator option to show

64
00:04:46,960 --> 00:04:54,820
the second label as a new line. Instead of a comma we have a new line so the number is below the category

65
00:04:54,820 --> 00:04:55,930
name.

66
00:04:55,930 --> 00:04:59,210
Once we have the labels activated we don't need the legends.

67
00:04:59,230 --> 00:05:03,430
I can remove that. Now for the series options as a whole.

68
00:05:03,460 --> 00:05:05,150
We have two options.

69
00:05:05,170 --> 00:05:07,950
We can decide on the angle of the first slice.

70
00:05:07,960 --> 00:05:14,050
If I just increase this notice that the angle of the first one is shifting. I'm just going to go

71
00:05:14,050 --> 00:05:15,340
with zero.

72
00:05:15,340 --> 00:05:17,930
We can also decide on the pie explosion.

73
00:05:17,950 --> 00:05:27,100
The higher I bring this, the smaller and more apart each of the piece of the pie becomes. One thing

74
00:05:27,100 --> 00:05:34,330
to note is that the pie chart is one of Excel standard charts. It is more flexible than the newer

75
00:05:34,330 --> 00:05:40,900
charts introduced. You can connect the title of the chart to a cell value.

76
00:05:40,900 --> 00:05:43,540
Now let's take a look at creating a doughnut chart.

77
00:05:45,830 --> 00:05:50,030
Doughnut charts are pie charts that have a hole in the middle.

78
00:05:50,120 --> 00:05:55,400
Instead of creating a doughnut chart from scratch, I'm just going to take this pie chart and change

79
00:05:55,400 --> 00:05:57,260
the chart type to a doughnut chart.

80
00:05:57,280 --> 00:06:00,900
Now when I click inside the series here.

81
00:06:00,920 --> 00:06:06,560
I have the option change series chart type. When I click outside in my plot area.

82
00:06:06,560 --> 00:06:10,030
I have change chart type. I'm going to go with this option.

83
00:06:10,040 --> 00:06:14,240
I want a doughnut chart. The doughnut is sitting in the pie chart options.

84
00:06:14,390 --> 00:06:17,180
It's the last one, select it and click on ok.

85
00:06:17,200 --> 00:06:21,050
I have a pie chart with a hole in it.

86
00:06:21,050 --> 00:06:24,280
Let's just take a look at the series options here.

87
00:06:24,290 --> 00:06:28,280
I have one additional option that I didn't have with a pie chart.

88
00:06:28,280 --> 00:06:28,950
What's that?

89
00:06:29,780 --> 00:06:38,600
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

90
00:06:38,690 --> 00:06:39,900
a pie chart.

91
00:06:39,920 --> 00:06:42,470
Let's go with 40 percent.

92
00:06:42,470 --> 00:06:45,740
That's how you can create a doughnut chart in Excel.