 a very good morning so today we will be continuing our biostatistics classes so today we are seeing how to make a pie chart from the excel sheet okay so it's a very easy technique if you have an excel sheet all laptops will be having so you need to open up an excel page so I have an excel sheet here so usually in excel all statistical and graphical works can be done but a professional can do very well but a beginner can do very easily so pie chart is basically very simple it will help mainly the post graduates or other people who are related to business or any other statistical field so first we need to open up an excel sheet and suppose let's take an example so we have a class of 100 people and we just take the gender distribution that is male sir I kept 100 just to get an idea and the basic thing about pie charts or pie diagram we have to use percentage wise data in pie chart not the data such as a height weight pressure usually we put percentage wise data so then only it will be easy to understand because the pie will be 100% always so let's go into the example so we have male 42 and female 58 that is 42 percentage and 58 percentage so we have to select this it's to select and go to the insert option click insert and you have pie here you can click on the pie so you get many different varieties that is 2d pie 3d pie so let's take a 3d pie so you get the pie chart okay so this is a pie chart so you have the blue color male and red color female now arrange it or you need to elaborate it so yeah so the first thing what you can do is click on the legends okay just click on when this icon comes here click on it so there will be a border so you have to do right click so we'll get a pop-up like this then you have to click on the format legend okay so format legend will come I'll show you what happens when you click on the different options so if you keep top the legends will move top side bottom left right top right usually it will be kept at bottom because at the top there will be title okay so you have many options you can keep a color for this one legends or gradient fill you can do some picture you can keep a picture but it is fine just a solid fill is fine then you can give border color right for the legends just give some orange color and you increase transparency so it is not very obvious about a style chart also you can keep so many options are there so don't worry much about this options we just keep the legends at bottom next we have we need to represent the percentage okay how much data the each section of pi is having so just click on the pi do the right click and click on add data labels okay so you get 58 percentage here and 42 percentage labels okay so in data labels if you put percentage this percentage will come just deselect and select this value so just percentage will come okay so you can keep this position at center inside and side and all the best fit so outside and looks fine also best fit anything is good I can put color also so you can keep on innovating on this this color so again you can fill this color and there's art area that you have to go here and put some green color now we need to add a title for this so we have to first you have to select this okay select the picture select click on the picture then otherwise it won't pop up now it will be just up to view look on this come design layout and formats we have to click on layout okay so the chart title how to click on above chart okay so distribution distribution so we get distribution of gender you can type on this distribution of gender now we have made pie chart so pie chart with male 58 percentage and female 42 percentage now we have an option you can go to design okay I can keep on changing this like this without legends legends will come here and here like this legends will go up and this way keep on trying something same way male female without percentage just with comma and like this okay so you have many options go back to title so next thing is you have many different types of pie charts here so I'm going for anything keep on changing this so you can select any of the options here nothing you're not happy with anything you can just undo it so it's very simple basically I'm making a pie chart and now let's do a different example the same class so what I mentioned was this is total 100% so this pie is 360 degree and always should be 100% so if you have a data which should be presented in a graphical manner that consists of percentage which is totally 100% so you can use a pie chart okay this is also I kept it 100% the age distribution of the same participants okay we don't need to put any title here you can always modify at the end so just put the categories and percentage just select go to insert can opt this one okay this is both are pie this is a different pie can select this different one looks like a donut rather than a pie okay now you get like this this is a donut and similar way we'll put the legend at bottom we're not working much on the legends you click on the donut right click data label and on the data we put format data label so we need just percentage okay so I put percentage just as we kept percentage and we are going to color this so there'll be color this is area color this is letter color so we put some color and next you go to the design if you want some other design so stick on to this we can try this one so I kept this one instead of legends this time or I can keep this one I think I will do this now we can change the chart title if it is not then I'm not worried suppose if it's not there you just go to the layout click here chart title can keep anywhere it is if centered or overlay title and above the chart it will come very close so better always keep it above the chart so distribution based on so this is distribution based on age so put some color good color I kept legend within the chart so this way I can easily make it any beginner can easily make any pie chart and you can keep on innovating always see what is there in the right click all the key elements are in light click away and keep on modifying it so that's all about pie diagram so all of you can just try an example can make sure that it is in percentage if it is like age like it is mean and standard deviation we have to do a bar graph or a histogram or you can do a line gram also but so far we just keep in mind that if percentage comes stick on to the pie diagrams or the donuts that's all about today so I'll come up with the bar graphs and line graphs in future classes thank you