hello everyone welcome to the channel of
WallStreetmojo to know more about
this video pie chart in Excel watch the
video till the end if you're new to this
channel then you can subscribe us by
clicking the bell icon that's given below
welcome everyone so today this topic pie
chart in Excel see it's it makes us very
it makes it very easy to compare
proportion and each value is shown you
know in in this as a slice now it is
shown in the value of slice of the pie
so it's easy to see which values make up
the percentage of a whole now the pie
charts are used to display the
contribution of each value slice to or
total pie so the excel pie chart uses
one data series so we will see what are
the steps to create a pie chart in Excel
now to create a pie chart in Excel 2017
data series well execute we need to
execute some of the following things
like you know here it's pure dolphin and
wells or when you open this this is the
first thing is that you know you need to
select the whole range after selecting
the range on the insert column ok on the
insert column it's written insert pie or
chart I mean  ok fine we'll do that
now you need to select any of this chart
ok so it says pie use the it says use this
chart type to show proportion of the
hole it will show you the proportion
what exactly comprises off and it uses
it use it when when the number equals
100% so the chart contains only a
few pie slices and many slices makes the
angle hard to estimate okay fourth what
you need to do is is you need to click
on the pie and select the whole pie
click on the slice to drag it away from
the center you know well
it depends you know what sort of chart
you want to do what you want to chart
what sort of chart you want to make okay
so again if you have selected insert you
know if you want like this whatever way
you want things can be displayed right
so those are the number of years and
this is showing us pairs and so does it
will show us for the rest well pie chart
this the size of the item is one data
series and proportional to the sum of
the other items and the data point in
the pie chart I've shown you know as a
percentage of the whole pie so to create
a pie chart Excel arrange the data in
one column or a row of the worksheet now
I want to discuss what are the types
what are the what are the types of pie
chart let's discuss that first is simple
pie then there is a 3D pie then
there is a pie of pie chart then we have
bar of pie chart and the last I would
say donut chart well we'll see the first
or the 3d chart now exactly a 3d chart
walk see or 3D chart or a perspective of
a pie chart is used to give a chart in
or a 3D look basically and often it is
uses aesthetic reasons the third
dimension does not improve the reading
of the data and on the contrary this
plots are very difficult to interpret
because of the distorted effects of the
perspective associated with the third
dimension so the use of these
superficial dimensions are not used to
display the data of the interest and it
is discouraged for you know charts in
general and not only for the pie charts
well how we are going to do this so well
I'll just delete this for the time being
well I'll select this company a and the
percentage part now again go to the
insert and go to the 3d chart well you
have a company a and the percentages are
already given I mean company a if select
this it shows a 16% and so
and so forth so if you want to create a
pie chart that shows your company with
the greatest positive light you know it
it shows things out here you know it
says that in a company a is 15% Company
B is over here it shows specifically as
12% and so on and so forth it goes right
well in this particular regard is if you
want to create a pie chart that shows
your company what you need to do you
just need to go to insert and data range
select this the whole thing insert tab
and then the chart group in the chart
you can select the 3d chart and once you
go here select this chart okay after
doing that just go down here make a edit
any text that you want to if you if you
want to change anything you know you
want to edit text or change of the type
or you know if you want to fill anything
out line anything you can do that right
well this is how things can be done so
we have studied the first type of chart
that is normal pie chart then there is a
pie of pie and then there is a bar of a pie
chart so if you have a several parts of
the something whole you can demonstrate
each item in one pie chart in Excel but
when several parts of each item is to
less than 10% well in that particular
regard it becomes really hard to
distinguish the slices so how does that
exactly works well we will try and
demonstrate that particular thing here
for example like if you have several
companies that operates on the market
and you can represent a part of every
company on the market as a slice how
you're going to do well you can
represent a part of every coming in the
market as a slice here something like
this company a and total with the chart
title you have to give
insert and you can show this kind of a
chart right so the data contains you
know the five slices you know that is a
below 10% and if you don't want this
kind of a chart then you can go insert
again and change the type of the chart
whatever you feel like
so to make this smaller size is more
visible in pie chart into Excel provides
a pie of pie chart and the bar of pie
there those are the sub sub parts and
each of the sub types you know separate
is the smaller slices from the main pie
chart and it displays them in an
additional pie or a stacked by h-pipe
stacked bar chart so to create a pie of
pie or a bar of pie in Excel what you
need to do is simply you need to I'll
just delete this again so that you know
you have a clear idea select this whole
thing then again go to the insert column
in that particular regards select this
chart which is this is pie of pie and
this is bar of pie er right I hope you
guys are clear on that particular
regards so this is bar of pie and if you
want to change then this is sorry this
is the first one is Pie of Pie and this is
bar of pie and rightly so you can go in
the format date and you know keep
changing your data that's absolutely
fine that you can do it now the donut
chart is a variant of the pie in the
excel file the two charts are quite
similar in the way they look and
function there are some of the features
of the donut charts which set them apart
the force is the donut chart are like
you know the cut-out
chart or the they are they are cut out
from the center the center of the donut
chart can be used to render additional
information like the total loss of all
the data values as well as you know the
data values of the slice being homeward
upon so in this case then rendering the
data labels and data values separately
are not at all required well so in that
particular regards what you can do you
can select this whole thing what we had
then you know what you do you can go
down to the insert column okay then
there was insert pie or a donuts chart
this one well we have this kind of a
chart is a donuts chart okay you can see
this so for example if you have several
companies that operates in one business
you can submit a part of every company
in this business every company
everything is visible here right so
after this merger of some of the
companies have you know received let's
say we hear there are some of the
companies that have been merged so now what you know so you can keep repairing
different sort of charts that you want
you know let's prepare a 3d chart or
whatever chart that you feel like that
is appropriate okay well this is how you
can create chart after chart and
different charts can be prepared this
for the 3 important charts that you
are supposed to learn and again I want
to repeat there are three kind of chart
the first one was the 2d 3d and the
donut chart and in the pie in the pie
chart
2d pie chart there are the first one is
the normal pie the second one is a pie
of pie which again I want to read that
you know what are the use of the chart
it shows the proportion of the hole and
it takes some values from the first pie
and it combines them in the second pie
basically it is making a lighter version
in terms of the values or probably some
percentages and it is it is useful for
you know if you want a more readable
values in the second pie in the similar
situation is bar of pie and you can see
the data that is visible visible again
the proportion of the whole it just the
only difference is that you know it's
take bar to make you know the small
percentage more readable and highlight
able so well I hope you guys have got a
fantastic idea regarding this particular
topic and if you have learned and
enjoyed watching this video please like
comment on this video and subscribe to
our channel for all the latest updates
thank you everyone once again cheers
