In this video we will learn to draw two graphs.
One is called Sunburst graph and the other one is called remap.
Both of these graphs are rarely used.
In fact I've never used it in my professional life but just to understand and know what these graphs
mean and how we can use them.
Let us learn in this we do so Sunburst and three maps are used when d d d had article that is in our
data.
There are some categories and within those categories there are further subcategories and for those
categories there are further more subcategories so there is a hierarchy in the data and corresponding
to that head of D.
There is a corresponding number so when you want to represent this hierarchical relationship between
the data and the corresponding contribution of each category and the subcategory Sunburst or tree map
graph can be used.
So for example purpose.
I have used the sample data of which country is winning how many medals in which sport.
So as you can see the first three rows are for the United States in the sport of athletics.
They have won 32 medals in Olympics in the sport of gymnastics.
They have gold medals and in swimming they have 33.
Next comes China for which we have finals then it's great Britain.
Then we have Russian Federation.
And lastly we have Germany participating in two sports
and when they draw us on both graph of it you can see the first inner circle is presenting the countries
that is that we have United States China Great Britain Russia and Germany here and the Auckland of each
of these countries is giving us the total number of medals onboard that country in Olympics when we
move outside of the circle.
The second circle is giving these subcategories.
That is the sport in which each country won the medals.
So United State won these medals in three sport.
That is why this arc of United States is further divided into three subcategories which is giving us
before the contribution of each sport to the medal count.
Similarly for China we have five subcategories for the Russian Federation.
We have three subcategories and so on.
So overall you can see that the sunburst love is first showing you the primary category.
Just like a doughnut jar but in a doughnut jar.
The second circle was same set of categories with a different data values in sunburst.
The second circle is a different set of categories that is subcategories of the primary categories.
This is what is made by us on both graph.
Let us now learn how to create one.
I believe this.
You will select this data
and we will go to Insert menu where there is the option of insert at our key chart within this we have
three map and Sunburst.
First we will clear does on both chart.
You can see a sunburst chart is created.
So remember whenever you are creating a sunburst chart your data should be in this order that the primary
categories should be the first column.
The secondary categories should be the second column and the final value.
Now do you want to show is in the third column.
If it is not in this format you can always go to the selected option and duty data accordingly.
Now to add several jarred element such as legend you can just click on those.
That plus button and add diligence
as we have already discussed.
You can open the formatting options to change the radius of these inner and outer circles to increase
the gap to change the colors and borders and I'll let you know how to do that as an exercise.
Just try it on your own to change the color of these icons.
Now let's move on to the team app.
So again we are going to use the same data stream app is also used to represent identical data.
So in Sunburst graph the art talent was giving us the contribution of that particular category and subcategory
in three maps.
The area of direct angle gives us the contribution of that particular category and category.
Also you can see that a tree map is much more clean and it makes it easy for us to compare different
categories enterprise degrees and go belt and do a sunburst graph.
However still I do not think that a dream map order Sunburst map can be used to convey any particular
message or they can be telling any story.
That's why I do not recommend using any of these still if you have the option probably go with a dream
app instead of a sunburst.
So how do we interpret our dream up.
You can see here this blue color region is for the United States which is written on top left and each
subcategory of United States is in this bottom left corner.
That is this first rectangle is for this looming the second rectangle is for athletics and this third
rectangle is for gymnastics the area of swimming that panel will give you the contribution of swimming
as a sport to the total medal count of United States.
If you move next this orange spot is for China and it has five different subcategories.
Therefore we have five rectangles.
Next is for Russian Federation which has three smaller tangles.
Great Britain has three rectangles and Germany has two rectangles.
And by visual inspection you can see that the United States has the maximum number of medals going out
of these five countries.
I do that swimming and probably athletics up contributing the most medals to the total gold.
So does it all be interpreted remap drawing it is also very simple.
The leaders select the holiday the
go to insert Iraqi maps dream up to there's a dreamer I mean you can add or remove dark elements you
can format the colors our borders change fellows using different lighting options.