1 00:00:03,260 --> 00:00:09,720 In this video we will learn why not by judge and how to drop a chart. 2 00:00:09,740 --> 00:00:18,130 A pie chart is useful when you want to show relative proportions or contributions to a whole pie chart 3 00:00:18,140 --> 00:00:26,380 can use only one data cities pie charts are most effective with a small number of data points. 4 00:00:26,690 --> 00:00:34,220 For example you must have seen such kind of pie chart showing the votes or seats won by different political 5 00:00:34,220 --> 00:00:38,090 parties during elections. 6 00:00:38,540 --> 00:00:47,930 Generally a pie chart should not use more than 5 or 6 data points that is slices a pie chart with too 7 00:00:47,930 --> 00:00:55,400 many data points can be very difficult to interpret in this simple example here I have the unit sort 8 00:00:55,550 --> 00:01:06,410 of different product in this table and I am creating a pie chart showing the contribution of each of 9 00:01:06,410 --> 00:01:08,170 these product to the total. 10 00:01:10,790 --> 00:01:18,380 So you can see the largest contribution is this orange slice which represents banks which has a value 11 00:01:18,380 --> 00:01:21,740 of one thousand eighty two. 12 00:01:21,740 --> 00:01:26,690 It is very difficult to read this pie chart because it has missing data labels. 13 00:01:26,690 --> 00:01:33,460 I do not know what is the contribution of each individual product to the total. 14 00:01:33,620 --> 00:01:41,480 So I would like to add the data labels but before that let me tell you how to create this chart first. 15 00:01:41,590 --> 00:01:44,010 I believe this selected table 16 00:01:47,470 --> 00:01:55,360 go to insert recommended chart and you can see that Excel is itself recommending this pie chart. 17 00:01:56,680 --> 00:02:03,010 If you do not find the pie chart option in the recommended charts option you can always go to the this 18 00:02:03,280 --> 00:02:11,710 symbol which is represented by each chart and you can select a pie chart did so I have this pie chart. 19 00:02:12,130 --> 00:02:14,040 I want to add data labels. 20 00:02:14,050 --> 00:02:18,030 I click on this plus button and add data labels. 21 00:02:18,550 --> 00:02:23,900 So now you can see that it is by default coming at the center. 22 00:02:24,070 --> 00:02:29,460 You have the option of changing the position of these data labels. 23 00:02:29,470 --> 00:02:36,850 If you wanted to come outside you can select out today or if you want it as a data cloud you can use 24 00:02:36,990 --> 00:02:37,290 that. 25 00:02:39,850 --> 00:02:47,110 But these are still numerical values if you would like to see the percentage contribution of each product 26 00:02:47,770 --> 00:02:58,840 you can go to the data series formatting options and instead of value here you can put percentage so 27 00:02:58,840 --> 00:03:06,260 you can see forty eight percent of the total tables was contributed by banks product. 28 00:03:06,280 --> 00:03:13,960 If you want multiple data labels like if you want category name and value and percentage you can add 29 00:03:13,960 --> 00:03:17,320 all of those all these three information will be shown. 30 00:03:17,350 --> 00:03:18,430 Separated by commas 31 00:03:21,800 --> 00:03:24,300 if we want to highlight any particular product. 32 00:03:24,500 --> 00:03:32,210 So for example I want to highlight that only 8 percent of my sales is contributed by showed. 33 00:03:32,300 --> 00:03:38,830 You can select that particular slice by double living on it and dragging and dropping it somewhere else. 34 00:03:38,840 --> 00:03:42,200 So this is called exploding the pie chart. 35 00:03:42,380 --> 00:03:48,200 You can explore individual slices on more than one slices also. 36 00:03:48,890 --> 00:03:56,990 This draws attention of the viewers towards this particular contributor to this place. 37 00:03:57,170 --> 00:04:02,900 Now let us go to the pie chart options and let us look what are the different types of pie charts we 38 00:04:02,900 --> 00:04:04,000 can draw. 39 00:04:07,510 --> 00:04:12,400 So the first one we have already drawn which is a simple pie chart. 40 00:04:12,430 --> 00:04:14,440 The second one is a 3D pie. 41 00:04:14,440 --> 00:04:21,400 It is exactly similar to the previous one just that it has a third dimension of giving the height to 42 00:04:21,400 --> 00:04:28,390 that pie which is really useless but still to make it more visually appealing. 43 00:04:28,390 --> 00:04:37,720 You can probably do the 3D by J then these next two options are by way of pie and the second one is 44 00:04:37,830 --> 00:04:48,520 bought off by the payoff pie and board of pie chart enables you to display a secondary chart that provide 45 00:04:48,670 --> 00:04:52,830 more detail for one of the pie slices. 46 00:04:53,200 --> 00:04:53,830 For example 47 00:04:56,890 --> 00:05:07,130 if I have data like this the fourth contributor which was others if it has four separate subcategories. 48 00:05:07,750 --> 00:05:15,640 If I create a single pie chart of all seven of these pages I will be very cluttered and I also want 49 00:05:15,640 --> 00:05:20,290 to emphasize that the last four are not a separate product for us. 50 00:05:20,290 --> 00:05:23,800 We consider them as a single others product. 51 00:05:24,040 --> 00:05:27,550 It has just four subcategories to it. 52 00:05:27,760 --> 00:05:34,890 In that case what I can do is I can blow it up first by jacket which will have both products. 53 00:05:34,940 --> 00:05:43,750 Short pants jeans and others and these others by will be exploded into another pie and it will have 54 00:05:43,990 --> 00:05:47,270 four other slices. 55 00:05:47,950 --> 00:05:57,080 So the read by jug or the bar chart can clearly provide the additional breakdown of the others contributed. 56 00:05:58,750 --> 00:06:00,970 So how do I draw this. 57 00:06:01,150 --> 00:06:03,820 Let me delete this one first. 58 00:06:06,010 --> 00:06:13,510 Now select this table and select these by your pie chart. 59 00:06:14,170 --> 00:06:18,080 You can see that your by jug is not in the recommended Taj option. 60 00:06:18,310 --> 00:06:29,710 So I'll go to all jarred by analogy old lady by your Bijan you can see that instead of last four subcategories 61 00:06:29,890 --> 00:06:31,570 which were to be combined. 62 00:06:31,570 --> 00:06:35,030 It has added only last three categories. 63 00:06:35,200 --> 00:06:39,760 The others socks category is part of the main pie. 64 00:06:40,060 --> 00:06:48,520 Instead of being part of the secondary body to correct this we will select debate. 65 00:06:48,640 --> 00:06:56,510 We will go to the data format data cities options in this third option. 66 00:06:57,340 --> 00:07:03,820 Since we want the last four subcategories to be part of the second debate we can select disposition 67 00:07:03,940 --> 00:07:12,150 option and tailored that the last four values in my table should belong to the second debate. 68 00:07:12,220 --> 00:07:19,580 You can see this is a chart that we actually wanted. 69 00:07:19,610 --> 00:07:22,800 There are other options of splitting the cities also. 70 00:07:23,060 --> 00:07:32,000 For example if you select value here you can tell it below which value you want to prosper. 71 00:07:32,000 --> 00:07:35,040 The places from primary just to secondary charge. 72 00:07:35,150 --> 00:07:42,440 So for example if I put 4000 here all the individual categories which have value less than 4000 will 73 00:07:42,440 --> 00:07:48,330 be part of the candy jar and which have more than 4000 value will be part of the primary job. 74 00:07:48,840 --> 00:07:50,740 Third is giving the same result. 75 00:07:53,370 --> 00:07:57,830 Similarly there is a percentage value which you can give. 76 00:07:57,980 --> 00:08:08,580 Again if I put 20 percent it cleared set out so probably nearly 15 percent will give me did a job which 77 00:08:08,580 --> 00:08:11,240 I intend to draw. 78 00:08:11,340 --> 00:08:12,570 There it is. 79 00:08:12,690 --> 00:08:20,520 And the last option to do Broadhead is custom where I can select a particular by a particular slice 80 00:08:20,730 --> 00:08:25,980 of a pie chart and tell it to go to primary plot or the secondary plot 81 00:08:31,910 --> 00:08:34,700 similar is the board of pie chart. 82 00:08:35,330 --> 00:08:44,240 If I select this one and two integer type 2 board of Bajor only that the secondary by judge is now a 83 00:08:44,240 --> 00:08:52,780 bar chart and the contribution of each subcategory is the height of this. 84 00:08:53,960 --> 00:09:00,830 So it is Lagos tagged by column and the height of each subcategory is telling you the contribution of 85 00:09:01,010 --> 00:09:03,170 each subcategory. 86 00:09:03,170 --> 00:09:13,390 Again remember that up a pie chart should have read the labels so we will select data levels to be our 87 00:09:13,510 --> 00:09:17,120 time or best fit whichever you prefer. 88 00:09:18,860 --> 00:09:25,010 If you want it to be percentages you can always select those and change the label options to percentage 89 00:09:36,870 --> 00:09:41,670 the last option in the pie chart is a doughnut chart 90 00:09:45,240 --> 00:09:50,740 are donor charges similar to a pie chart but it has two differences. 91 00:09:50,740 --> 00:09:53,250 One is that it has a hole in the middle. 92 00:09:54,070 --> 00:09:59,610 And second is that it can display more than once it is already done. 93 00:10:00,190 --> 00:10:09,000 In this example I have two data series one for the year 2000 A.D. and the other four year 2019. 94 00:10:09,390 --> 00:10:15,770 And I want to plot the contribution of my product to the total tables in these two years. 95 00:10:15,790 --> 00:10:22,350 How is the contribution changing for each product to instead of creating two different pie charts. 96 00:10:22,630 --> 00:10:29,800 I have created a single donor chart you can see that the inner circle is giving me the contribution 97 00:10:29,800 --> 00:10:36,770 or Product of 2000 A.D. here and the older one is giving the contribution of 2019. 98 00:10:39,820 --> 00:10:48,530 And from this pie you can see the contribution of sharks has increased for balance. 99 00:10:48,550 --> 00:10:53,730 I'm not really sure because the base line has moved so I'm not really sure whether it has increased 100 00:10:53,740 --> 00:10:54,640 or not. 101 00:10:54,630 --> 00:10:59,590 Probably if I add data levels I'll be able to compare. 102 00:10:59,650 --> 00:11:01,600 Same goes with the other categories. 103 00:11:02,160 --> 00:11:09,370 So although this looks visually appealing it is very difficult to compare the contribution of product 104 00:11:09,520 --> 00:11:17,700 using a donor chart and instead of this stat column chart will be a much better choice. 105 00:11:17,800 --> 00:11:30,420 So let us see how to draw this one well the league selected it will go to insert and you can see that 106 00:11:31,110 --> 00:11:40,710 by default Excel is telling you the column chart instead of this we are drawing a donor chart. 107 00:11:42,690 --> 00:11:44,490 So this is a donor chart. 108 00:11:44,940 --> 00:11:56,920 Okay here's a donor chart you can add data levels again by clicking this plus sign to click on this. 109 00:11:57,210 --> 00:11:58,850 Do you have your data level. 110 00:11:58,870 --> 00:12:03,060 You can position them change people using all these data labels to make them more readable 111 00:12:07,790 --> 00:12:11,750 however since you already have a lot of categories. 112 00:12:11,750 --> 00:12:18,860 This chart is going to be cluttered and there is no way this will look good in the formatting options. 113 00:12:18,860 --> 00:12:26,660 You can change the weight of these things you can do that by clicking any of these and opening opening 114 00:12:26,660 --> 00:12:37,760 day formatting options and then you can reduce the donut hole size to make these rings ticker. 115 00:12:37,820 --> 00:12:45,140 You can also change these numbers to percentages by similarly going to the label options and changing 116 00:12:45,740 --> 00:12:47,030 values to percentages. 117 00:12:48,450 --> 00:12:57,000 So although this type of charge would be used very sparingly we have covered the donut chart just so 118 00:12:57,000 --> 00:12:58,350 that do you know how to draw an.