In this video, we will learn what that pie chart and how to draw a pie chart, a pie chart is useful
when you want to show relative proportions or contributions to a whole.
A pie chart can use only one dataset.
Fighters are most effective with a small number of data points.
For example, you must have seen such kind of pie chart showing the votes or seats won by different
political parties during elections.
Generally, a pie chart should not use more than five or six data point.
That is, slices of pie chart with too many data points can be very difficult to interpret.
And this simple example here I have the unit sort of different product in this table and I'm creating
a pie chart showing the contribution of each of these products to the total.
So you can see the largest contribution is this orange slice, which represents band, which has a value
of 1082.
It is very difficult to read this pie chart because it has missing data labels.
I do not know what is the contribution of each individual product to the total.
So I would like to add the data labels.
But before that, let me tell you how to create this chart first and the latest selectable.
Go to insert recommended charge and you can see that Excel is itself recommending this pie chart, if
you do not find the pie chart option in the recommended charts option, you can always go to the this
symbol, which is representing pie chart, and you can select a pie chart there.
So I have this pie chart.
I want to add to the labels.
I click on this plus button and add little labels so you can see that it is by default coming at Descender.
You have the option of changing the position of these labels.
If you wanted to come outside, you can select, alternate or if you want it as a data Kholoud, you
can use that.
But these are still numerical values, if you like to see the percentage contribution of each product,
you can go to the dataset is formatting options.
And instead of value here, you can put percentage so you can see 48 percent of the total sales was
contributed by banks product.
If you want multiple data levels, like if you want category, name and value and percentage, you can
add all of those.
All these three information will be shown separated by commas.
If you want to highlight any particular product, so, for example, I want to highlight that only eight
percent of my sales is contributed by should you get like that particular slice by clicking on it and
dragging and dropping it somewhere else.
So this is called exploding the pie chart.
You can explode individual slices or more than one slices.
Also, this draws attention of the viewers towards this particular contributor to this place.
Now, let us go to the pie chart options and let us look what are the different types of pie charts
we can draw.
So the first one we have already drawn, which is a simple pie chart.
The second one, is it really pie?
It is exactly similar to the previous one does that it has a third dimension of giving the height to
that pie, which is really useless.
But still, to make it more visually appealing, you can probably do that really pie chart.
Then these next two options are by your pie.
And the second one is part of the pie of pie and part of pie chart enables you to display a second,
Richard, that provide more detail for one of the pie slices, for example.
If I have data like this, the fourth contributor, which was others, if it has four separate subcategories,
if I create a single pie chart of all seven of these, the pie chart will be very cluttered.
And I also want to emphasize that the last four are not a separate product for us.
We consider them as a single adult product.
It has just four subcategories to it.
In that case, what I can do is I can plot up first paycheck, which will have four products, short
pants, jeans and others, and these others buy will be exploded into another pipe and it will have
four other slices.
So this secondary Bajak or the bar chart can clearly provide the additional breakdown of the others
contributor.
So how to draw this?
Let me delete this one first.
Not select this table.
And selected by your pie chart, you can see that Buyoff pie chart is not in the recommended chart option,
so I'll go to all charts by an old lady pie of pie chart.
You can see that instead of last four subcategories, which were to be combined, it has added only
last three categories.
The other category is part of the main pie.
Instead of being part of the second group to correct this, we will select debate.
We will go to the data format, the city's options.
In this third option since we won the last four subcategories to be part of the second debate, we can
select this position option and tell it that the last four values in my table should belong to the second
debate.
You can see this is a chart that we actually wanted.
There are other options of splitting the series also.
For example, if you select value here, you can tell it below which value you want to transfer the
latest from primary to the reject.
So, for example, if I put 4000 here, all the individual categories which have value, less than 4000
will be part of the candidate and which are more than 4000 value will be part of the primary, just
is giving the same result.
Similarly, there's a percentage value which you can give again, if I put 20 percent, it creates a
toll, probably nearly 15 percent will give me the data, which I intend to draw.
There it is.
And the last option to draw here is custom, where I can select a particular by a particular slice of
the pie chart and tell it to go to primary plot or the secondary plot.
Similar is the board of Bajak, if I select this one and Type two board of Bajak only that the secondary
Bigart is in our budget and the contribution of each subcategory is the height of this board.
So it is like a the column and the height of each subcategory is telling you the contribution of each
subcategory again.
Remember that a arbeiter should have read labels.
So we will select digital labels to be outside our best fit, whichever you prefer, if you want it
to be percentages.
You can always select those and change the label options to percentage.
The last option in the pie chart is a doughnut chart.
A donor card similar to a pie chart, but it has two differences.
One is that it has a hole in the middle and is that it can display more than once it is.
Obledo in this example, I have two datasets, one for the year 2018 and the other four year 2019.
And I want to applaud the contribution of my product to the total sales in these two years.
How is the contribution changing for each product to instead of creating two different projects?
I have created a single donor chart.
You can see that the inner circle is giving me the contribution of product of 2000 Adania and the other
one is giving the contribution of 2019.
And from this point, you can see the contribution of shirts has increased for bands.
I'm not really sure because the base line has moved.
So I'm not really sure whether it has increased or not.
But I if I added data labels, I'll be able to compare.
Same goes with the other categories.
So although this looks visually appealing, it is very difficult to compare the contribution of product
using a donor card and instead of this Ustad column chart will be a much better choice.
So let us see how to draw this one.
Will delete selected.
Will go to insert.
And you can see that by default, Exit is telling you the column charts instead of this, we are drawing
a donor chart.
So this is a donor chart.
OK, here's the donor chart.
You can add data levels again by clicking this.
Plus, time to click on this.
You have your data levels.
You can position them, change the position of these data levels to make them more readable.
However, since we already have a lot of categories, this chart is going to be cluttered and there
is no way this will look good in the formatting options, you can change the weight of these rings.
You can do that by by clicking any of these and opening opening the formatting options.
And then you can reduce the donut hole size to make these rings thicker.
You can also change these numbers to percentages by similarly going to the label options and changing
values to percentages.
So although this type of charge would be used very sparingly, we have collected on a chart just so
that you know how to draw an.