1
00:00:01,740 --> 00:00:05,040
In this video we will learn to draw two graphs.

2
00:00:05,080 --> 00:00:09,670
One is called Sunburst graph and the other one is called remap.

3
00:00:09,700 --> 00:00:12,390
Both of these graphs are rarely used.

4
00:00:12,430 --> 00:00:20,950
In fact I've never used it in my professional life but just to understand and know what these graphs

5
00:00:20,980 --> 00:00:24,040
mean and how we can use them.

6
00:00:24,130 --> 00:00:35,290
Let us learn in this we do so Sunburst and three maps are used when d d d had article that is in our

7
00:00:35,290 --> 00:00:35,820
data.

8
00:00:35,860 --> 00:00:42,880
There are some categories and within those categories there are further subcategories and for those

9
00:00:42,930 --> 00:00:48,640
categories there are further more subcategories so there is a hierarchy in the data and corresponding

10
00:00:48,640 --> 00:00:49,730
to that head of D.

11
00:00:49,750 --> 00:00:56,620
There is a corresponding number so when you want to represent this hierarchical relationship between

12
00:00:56,620 --> 00:01:03,970
the data and the corresponding contribution of each category and the subcategory Sunburst or tree map

13
00:01:04,030 --> 00:01:06,540
graph can be used.

14
00:01:06,640 --> 00:01:08,300
So for example purpose.

15
00:01:08,320 --> 00:01:15,170
I have used the sample data of which country is winning how many medals in which sport.

16
00:01:15,870 --> 00:01:22,920
So as you can see the first three rows are for the United States in the sport of athletics.

17
00:01:22,920 --> 00:01:28,630
They have won 32 medals in Olympics in the sport of gymnastics.

18
00:01:28,720 --> 00:01:32,660
They have gold medals and in swimming they have 33.

19
00:01:32,670 --> 00:01:37,620
Next comes China for which we have finals then it's great Britain.

20
00:01:38,250 --> 00:01:39,720
Then we have Russian Federation.

21
00:01:39,720 --> 00:01:43,320
And lastly we have Germany participating in two sports

22
00:01:46,510 --> 00:01:53,590
and when they draw us on both graph of it you can see the first inner circle is presenting the countries

23
00:01:54,400 --> 00:02:04,240
that is that we have United States China Great Britain Russia and Germany here and the Auckland of each

24
00:02:04,240 --> 00:02:13,540
of these countries is giving us the total number of medals onboard that country in Olympics when we

25
00:02:13,540 --> 00:02:15,110
move outside of the circle.

26
00:02:15,190 --> 00:02:18,950
The second circle is giving these subcategories.

27
00:02:19,210 --> 00:02:24,140
That is the sport in which each country won the medals.

28
00:02:24,310 --> 00:02:29,080
So United State won these medals in three sport.

29
00:02:29,080 --> 00:02:37,030
That is why this arc of United States is further divided into three subcategories which is giving us

30
00:02:37,840 --> 00:02:41,350
before the contribution of each sport to the medal count.

31
00:02:43,210 --> 00:02:48,410
Similarly for China we have five subcategories for the Russian Federation.

32
00:02:48,460 --> 00:02:53,120
We have three subcategories and so on.

33
00:02:53,170 --> 00:03:00,910
So overall you can see that the sunburst love is first showing you the primary category.

34
00:03:01,150 --> 00:03:04,910
Just like a doughnut jar but in a doughnut jar.

35
00:03:05,110 --> 00:03:14,200
The second circle was same set of categories with a different data values in sunburst.

36
00:03:14,200 --> 00:03:23,150
The second circle is a different set of categories that is subcategories of the primary categories.

37
00:03:23,200 --> 00:03:26,600
This is what is made by us on both graph.

38
00:03:26,650 --> 00:03:30,180
Let us now learn how to create one.

39
00:03:30,540 --> 00:03:32,570
I believe this.

40
00:03:33,510 --> 00:03:34,690
You will select this data

41
00:03:37,930 --> 00:03:46,250
and we will go to Insert menu where there is the option of insert at our key chart within this we have

42
00:03:46,250 --> 00:03:47,500
three map and Sunburst.

43
00:03:47,510 --> 00:03:49,950
First we will clear does on both chart.

44
00:03:50,450 --> 00:03:53,460
You can see a sunburst chart is created.

45
00:03:53,730 --> 00:03:59,960
So remember whenever you are creating a sunburst chart your data should be in this order that the primary

46
00:04:00,920 --> 00:04:02,910
categories should be the first column.

47
00:04:02,930 --> 00:04:08,810
The secondary categories should be the second column and the final value.

48
00:04:08,810 --> 00:04:11,650
Now do you want to show is in the third column.

49
00:04:13,040 --> 00:04:19,840
If it is not in this format you can always go to the selected option and duty data accordingly.

50
00:04:19,850 --> 00:04:26,770
Now to add several jarred element such as legend you can just click on those.

51
00:04:26,930 --> 00:04:29,300
That plus button and add diligence

52
00:04:33,140 --> 00:04:34,990
as we have already discussed.

53
00:04:35,060 --> 00:04:41,930
You can open the formatting options to change the radius of these inner and outer circles to increase

54
00:04:41,930 --> 00:04:50,450
the gap to change the colors and borders and I'll let you know how to do that as an exercise.

55
00:04:50,450 --> 00:04:55,820
Just try it on your own to change the color of these icons.

56
00:04:55,820 --> 00:04:57,320
Now let's move on to the team app.

57
00:04:59,090 --> 00:05:05,330
So again we are going to use the same data stream app is also used to represent identical data.

58
00:05:07,130 --> 00:05:14,960
So in Sunburst graph the art talent was giving us the contribution of that particular category and subcategory

59
00:05:15,740 --> 00:05:16,750
in three maps.

60
00:05:16,820 --> 00:05:23,810
The area of direct angle gives us the contribution of that particular category and category.

61
00:05:24,200 --> 00:05:31,760
Also you can see that a tree map is much more clean and it makes it easy for us to compare different

62
00:05:31,760 --> 00:05:37,280
categories enterprise degrees and go belt and do a sunburst graph.

63
00:05:37,280 --> 00:05:43,070
However still I do not think that a dream map order Sunburst map can be used to convey any particular

64
00:05:43,070 --> 00:05:46,470
message or they can be telling any story.

65
00:05:46,490 --> 00:05:53,740
That's why I do not recommend using any of these still if you have the option probably go with a dream

66
00:05:53,730 --> 00:05:56,670
app instead of a sunburst.

67
00:05:56,760 --> 00:05:59,040
So how do we interpret our dream up.

68
00:05:59,040 --> 00:06:08,850
You can see here this blue color region is for the United States which is written on top left and each

69
00:06:08,850 --> 00:06:14,490
subcategory of United States is in this bottom left corner.

70
00:06:14,520 --> 00:06:23,610
That is this first rectangle is for this looming the second rectangle is for athletics and this third

71
00:06:23,610 --> 00:06:33,510
rectangle is for gymnastics the area of swimming that panel will give you the contribution of swimming

72
00:06:33,600 --> 00:06:38,860
as a sport to the total medal count of United States.

73
00:06:39,270 --> 00:06:48,170
If you move next this orange spot is for China and it has five different subcategories.

74
00:06:48,210 --> 00:06:51,680
Therefore we have five rectangles.

75
00:06:51,750 --> 00:06:55,380
Next is for Russian Federation which has three smaller tangles.

76
00:06:55,500 --> 00:07:00,750
Great Britain has three rectangles and Germany has two rectangles.

77
00:07:02,360 --> 00:07:09,890
And by visual inspection you can see that the United States has the maximum number of medals going out

78
00:07:09,900 --> 00:07:11,740
of these five countries.

79
00:07:11,750 --> 00:07:19,500
I do that swimming and probably athletics up contributing the most medals to the total gold.

80
00:07:21,870 --> 00:07:28,330
So does it all be interpreted remap drawing it is also very simple.

81
00:07:28,350 --> 00:07:30,360
The leaders select the holiday the

82
00:07:33,960 --> 00:07:46,770
go to insert Iraqi maps dream up to there's a dreamer I mean you can add or remove dark elements you

83
00:07:46,770 --> 00:07:53,100
can format the colors our borders change fellows using different lighting options.