1 00:00:03,180 --> 00:00:11,610 In this video, we will learn what that pie chart and how to draw a pie chart, a pie chart is useful 2 00:00:11,760 --> 00:00:15,750 when you want to show relative proportions or contributions to a whole. 3 00:00:17,430 --> 00:00:19,860 A pie chart can use only one dataset. 4 00:00:21,240 --> 00:00:25,050 Fighters are most effective with a small number of data points. 5 00:00:26,640 --> 00:00:33,750 For example, you must have seen such kind of pie chart showing the votes or seats won by different 6 00:00:33,750 --> 00:00:36,000 political parties during elections. 7 00:00:38,490 --> 00:00:44,010 Generally, a pie chart should not use more than five or six data point. 8 00:00:44,520 --> 00:00:50,630 That is, slices of pie chart with too many data points can be very difficult to interpret. 9 00:00:51,480 --> 00:01:01,950 And this simple example here I have the unit sort of different product in this table and I'm creating 10 00:01:01,950 --> 00:01:08,210 a pie chart showing the contribution of each of these products to the total. 11 00:01:10,740 --> 00:01:18,410 So you can see the largest contribution is this orange slice, which represents band, which has a value 12 00:01:18,410 --> 00:01:19,770 of 1082. 13 00:01:21,600 --> 00:01:26,070 It is very difficult to read this pie chart because it has missing data labels. 14 00:01:26,560 --> 00:01:33,050 I do not know what is the contribution of each individual product to the total. 15 00:01:33,570 --> 00:01:35,760 So I would like to add the data labels. 16 00:01:36,330 --> 00:01:43,800 But before that, let me tell you how to create this chart first and the latest selectable. 17 00:01:47,410 --> 00:01:56,830 Go to insert recommended charge and you can see that Excel is itself recommending this pie chart, if 18 00:01:56,830 --> 00:02:03,010 you do not find the pie chart option in the recommended charts option, you can always go to the this 19 00:02:03,220 --> 00:02:07,470 symbol, which is representing pie chart, and you can select a pie chart there. 20 00:02:09,430 --> 00:02:10,800 So I have this pie chart. 21 00:02:12,010 --> 00:02:13,570 I want to add to the labels. 22 00:02:13,930 --> 00:02:23,520 I click on this plus button and add little labels so you can see that it is by default coming at Descender. 23 00:02:24,010 --> 00:02:29,200 You have the option of changing the position of these labels. 24 00:02:29,380 --> 00:02:36,310 If you wanted to come outside, you can select, alternate or if you want it as a data Kholoud, you 25 00:02:36,310 --> 00:02:37,330 can use that. 26 00:02:39,820 --> 00:02:47,130 But these are still numerical values, if you like to see the percentage contribution of each product, 27 00:02:47,680 --> 00:02:50,710 you can go to the dataset is formatting options. 28 00:02:53,200 --> 00:03:03,490 And instead of value here, you can put percentage so you can see 48 percent of the total sales was 29 00:03:03,490 --> 00:03:05,590 contributed by banks product. 30 00:03:06,240 --> 00:03:13,630 If you want multiple data levels, like if you want category, name and value and percentage, you can 31 00:03:13,630 --> 00:03:14,590 add all of those. 32 00:03:14,860 --> 00:03:18,430 All these three information will be shown separated by commas. 33 00:03:21,730 --> 00:03:28,180 If you want to highlight any particular product, so, for example, I want to highlight that only eight 34 00:03:28,180 --> 00:03:36,100 percent of my sales is contributed by should you get like that particular slice by clicking on it and 35 00:03:36,400 --> 00:03:38,470 dragging and dropping it somewhere else. 36 00:03:38,800 --> 00:03:41,640 So this is called exploding the pie chart. 37 00:03:42,310 --> 00:03:46,550 You can explode individual slices or more than one slices. 38 00:03:46,570 --> 00:03:54,960 Also, this draws attention of the viewers towards this particular contributor to this place. 39 00:03:57,130 --> 00:04:02,800 Now, let us go to the pie chart options and let us look what are the different types of pie charts 40 00:04:02,800 --> 00:04:03,280 we can draw. 41 00:04:07,450 --> 00:04:11,750 So the first one we have already drawn, which is a simple pie chart. 42 00:04:12,370 --> 00:04:13,850 The second one, is it really pie? 43 00:04:14,320 --> 00:04:21,400 It is exactly similar to the previous one does that it has a third dimension of giving the height to 44 00:04:21,400 --> 00:04:24,010 that pie, which is really useless. 45 00:04:25,510 --> 00:04:31,090 But still, to make it more visually appealing, you can probably do that really pie chart. 46 00:04:33,010 --> 00:04:35,810 Then these next two options are by your pie. 47 00:04:36,340 --> 00:04:46,330 And the second one is part of the pie of pie and part of pie chart enables you to display a second, 48 00:04:46,330 --> 00:04:53,860 Richard, that provide more detail for one of the pie slices, for example. 49 00:04:56,810 --> 00:05:05,660 If I have data like this, the fourth contributor, which was others, if it has four separate subcategories, 50 00:05:07,670 --> 00:05:13,040 if I create a single pie chart of all seven of these, the pie chart will be very cluttered. 51 00:05:14,540 --> 00:05:20,080 And I also want to emphasize that the last four are not a separate product for us. 52 00:05:20,210 --> 00:05:23,050 We consider them as a single adult product. 53 00:05:23,930 --> 00:05:26,170 It has just four subcategories to it. 54 00:05:27,680 --> 00:05:35,510 In that case, what I can do is I can plot up first paycheck, which will have four products, short 55 00:05:35,520 --> 00:05:43,790 pants, jeans and others, and these others buy will be exploded into another pipe and it will have 56 00:05:43,940 --> 00:05:46,120 four other slices. 57 00:05:47,900 --> 00:05:56,390 So this secondary Bajak or the bar chart can clearly provide the additional breakdown of the others 58 00:05:56,390 --> 00:05:57,010 contributor. 59 00:05:58,700 --> 00:06:00,160 So how to draw this? 60 00:06:01,100 --> 00:06:02,450 Let me delete this one first. 61 00:06:05,930 --> 00:06:07,130 Not select this table. 62 00:06:09,660 --> 00:06:17,750 And selected by your pie chart, you can see that Buyoff pie chart is not in the recommended chart option, 63 00:06:18,240 --> 00:06:23,670 so I'll go to all charts by an old lady pie of pie chart. 64 00:06:26,230 --> 00:06:33,220 You can see that instead of last four subcategories, which were to be combined, it has added only 65 00:06:33,220 --> 00:06:34,330 last three categories. 66 00:06:35,150 --> 00:06:39,700 The other category is part of the main pie. 67 00:06:39,970 --> 00:06:48,000 Instead of being part of the second group to correct this, we will select debate. 68 00:06:48,580 --> 00:06:51,460 We will go to the data format, the city's options. 69 00:06:53,650 --> 00:07:02,980 In this third option since we won the last four subcategories to be part of the second debate, we can 70 00:07:02,980 --> 00:07:11,380 select this position option and tell it that the last four values in my table should belong to the second 71 00:07:11,380 --> 00:07:11,780 debate. 72 00:07:12,160 --> 00:07:16,250 You can see this is a chart that we actually wanted. 73 00:07:19,180 --> 00:07:21,940 There are other options of splitting the series also. 74 00:07:23,020 --> 00:07:32,320 For example, if you select value here, you can tell it below which value you want to transfer the 75 00:07:32,530 --> 00:07:34,860 latest from primary to the reject. 76 00:07:35,080 --> 00:07:41,980 So, for example, if I put 4000 here, all the individual categories which have value, less than 4000 77 00:07:42,190 --> 00:07:47,730 will be part of the candidate and which are more than 4000 value will be part of the primary, just 78 00:07:49,080 --> 00:07:50,730 is giving the same result. 79 00:07:53,340 --> 00:08:03,760 Similarly, there's a percentage value which you can give again, if I put 20 percent, it creates a 80 00:08:04,530 --> 00:08:09,430 toll, probably nearly 15 percent will give me the data, which I intend to draw. 81 00:08:11,340 --> 00:08:11,910 There it is. 82 00:08:12,570 --> 00:08:20,880 And the last option to draw here is custom, where I can select a particular by a particular slice of 83 00:08:20,880 --> 00:08:26,010 the pie chart and tell it to go to primary plot or the secondary plot. 84 00:08:31,860 --> 00:08:42,780 Similar is the board of Bajak, if I select this one and Type two board of Bajak only that the secondary 85 00:08:42,780 --> 00:08:52,780 Bigart is in our budget and the contribution of each subcategory is the height of this board. 86 00:08:53,910 --> 00:09:01,290 So it is like a the column and the height of each subcategory is telling you the contribution of each 87 00:09:01,440 --> 00:09:03,610 subcategory again. 88 00:09:03,630 --> 00:09:07,410 Remember that a arbeiter should have read labels. 89 00:09:08,820 --> 00:09:19,410 So we will select digital labels to be outside our best fit, whichever you prefer, if you want it 90 00:09:19,410 --> 00:09:20,460 to be percentages. 91 00:09:20,490 --> 00:09:25,020 You can always select those and change the label options to percentage. 92 00:09:36,860 --> 00:09:41,690 The last option in the pie chart is a doughnut chart. 93 00:09:45,250 --> 00:09:49,990 A donor card similar to a pie chart, but it has two differences. 94 00:09:50,710 --> 00:09:57,220 One is that it has a hole in the middle and is that it can display more than once it is. 95 00:09:57,220 --> 00:10:07,510 Obledo in this example, I have two datasets, one for the year 2018 and the other four year 2019. 96 00:10:09,280 --> 00:10:14,810 And I want to applaud the contribution of my product to the total sales in these two years. 97 00:10:15,700 --> 00:10:21,760 How is the contribution changing for each product to instead of creating two different projects? 98 00:10:22,510 --> 00:10:24,550 I have created a single donor chart. 99 00:10:25,510 --> 00:10:33,580 You can see that the inner circle is giving me the contribution of product of 2000 Adania and the other 100 00:10:33,580 --> 00:10:36,590 one is giving the contribution of 2019. 101 00:10:39,700 --> 00:10:48,450 And from this point, you can see the contribution of shirts has increased for bands. 102 00:10:48,460 --> 00:10:51,400 I'm not really sure because the base line has moved. 103 00:10:51,580 --> 00:10:54,150 So I'm not really sure whether it has increased or not. 104 00:10:54,470 --> 00:10:57,610 But I if I added data labels, I'll be able to compare. 105 00:10:59,590 --> 00:11:01,360 Same goes with the other categories. 106 00:11:02,120 --> 00:11:09,430 So although this looks visually appealing, it is very difficult to compare the contribution of product 107 00:11:09,430 --> 00:11:15,650 using a donor card and instead of this Ustad column chart will be a much better choice. 108 00:11:17,770 --> 00:11:19,600 So let us see how to draw this one. 109 00:11:20,460 --> 00:11:23,790 Will delete selected. 110 00:11:24,060 --> 00:11:25,990 Will go to insert. 111 00:11:28,270 --> 00:11:38,470 And you can see that by default, Exit is telling you the column charts instead of this, we are drawing 112 00:11:39,490 --> 00:11:40,710 a donor chart. 113 00:11:42,640 --> 00:11:44,470 So this is a donor chart. 114 00:11:44,890 --> 00:11:48,090 OK, here's the donor chart. 115 00:11:48,100 --> 00:11:51,880 You can add data levels again by clicking this. 116 00:11:51,880 --> 00:11:55,510 Plus, time to click on this. 117 00:11:57,130 --> 00:11:58,870 You have your data levels. 118 00:11:58,880 --> 00:12:03,070 You can position them, change the position of these data levels to make them more readable. 119 00:12:07,710 --> 00:12:14,310 However, since we already have a lot of categories, this chart is going to be cluttered and there 120 00:12:14,310 --> 00:12:22,280 is no way this will look good in the formatting options, you can change the weight of these rings. 121 00:12:22,980 --> 00:12:27,660 You can do that by by clicking any of these and opening opening the formatting options. 122 00:12:28,080 --> 00:12:34,590 And then you can reduce the donut hole size to make these rings thicker. 123 00:12:37,730 --> 00:12:45,140 You can also change these numbers to percentages by similarly going to the label options and changing 124 00:12:45,650 --> 00:12:47,030 values to percentages. 125 00:12:48,440 --> 00:12:56,990 So although this type of charge would be used very sparingly, we have collected on a chart just so 126 00:12:56,990 --> 00:12:58,370 that you know how to draw an.