1 00:00:02,060 --> 00:00:04,850 In this video we will learn how to create a pivot chart 2 00:00:07,880 --> 00:00:12,890 which charts a graphical representation of a picnic table. 3 00:00:12,890 --> 00:00:19,690 If you know about what pivot tables are and how to use them you can continue with this lecture. 4 00:00:20,690 --> 00:00:27,380 If you do not know about pivot tables the next lecture in the cities is about pivot tables. 5 00:00:27,410 --> 00:00:28,990 That lecture was part of it. 6 00:00:29,030 --> 00:00:31,660 Another course on Microsoft Excel. 7 00:00:31,700 --> 00:00:38,150 We have included here so that you can learn about pivot tables if you want to learn more about other 8 00:00:38,150 --> 00:00:41,330 such features of Microsoft Excel. 9 00:00:41,360 --> 00:00:51,130 You can enroll in another course of Excel master class so pivot tables basically summarize the data 10 00:00:52,150 --> 00:00:58,300 in the form of rows and columns and give the corresponding counting sums or different combination of 11 00:00:58,300 --> 00:00:59,850 categories. 12 00:00:59,980 --> 00:01:05,710 So for example in this table I have little furniture sales. 13 00:01:05,740 --> 00:01:14,640 The first column is giving me this sales person the next column tells me what product that salesperson 14 00:01:14,770 --> 00:01:16,460 sold. 15 00:01:16,660 --> 00:01:22,090 Next column is which region does that salesperson belong. 16 00:01:22,240 --> 00:01:25,630 Then we get the name of the customer. 17 00:01:25,870 --> 00:01:28,160 Then is the date of sale. 18 00:01:28,270 --> 00:01:30,660 Then we have the item cost. 19 00:01:30,760 --> 00:01:35,500 Then we have the number of items sold and then we have the total cost. 20 00:01:35,500 --> 00:01:38,950 So I have all these transactions. 21 00:01:38,950 --> 00:01:45,490 So every sales person whenever he is selling any particular product that transaction is noted down into 22 00:01:45,490 --> 00:01:47,370 this table. 23 00:01:47,440 --> 00:01:57,730 If I want to get the total number of chairs sold by salesperson Well I can do that by using these filters 24 00:02:02,730 --> 00:02:04,740 and setting that as 6 percent will 25 00:02:07,940 --> 00:02:19,100 and then I can add the total cost of the number of items which are what I want to get the total number 26 00:02:19,100 --> 00:02:25,440 of chairs sold by salesperson so this is a very lengthy process. 27 00:02:25,440 --> 00:02:33,830 Also if I want to compare the JSE is by each individual salesperson that becomes even more Lindy. 28 00:02:33,870 --> 00:02:40,920 This is where summarizing the data using a pivot table helps us turn the next sheet. 29 00:02:41,310 --> 00:02:49,980 You can see on the left is a pivot table which can summarize the data as I want it to be corresponding 30 00:02:49,980 --> 00:02:51,880 to this table. 31 00:02:52,020 --> 00:03:02,730 I can draw corresponding with a chart so as you can see since I had the rule labels on the left. 32 00:03:02,850 --> 00:03:08,910 These rule labels are coming as the horizontal axis labeled in this chart. 33 00:03:09,450 --> 00:03:20,660 These two series that is the two names of our customers is the two cities plotted here and on the y 34 00:03:20,660 --> 00:03:21,580 axis. 35 00:03:21,630 --> 00:03:30,460 I am getting the value of total cost for each customer. 36 00:03:30,460 --> 00:03:37,640 Apart from that I have added a freighter which is for region although I have not selected any region. 37 00:03:37,690 --> 00:03:39,810 Same is depicted in this graph. 38 00:03:39,910 --> 00:03:44,860 There is a free debt of region but there is no particular region selected. 39 00:03:46,300 --> 00:03:53,530 So as you can see the difference between a normal bar graph and a pyramid bar graph is that you get 40 00:03:53,800 --> 00:04:05,500 all these options of data of choosing the required axis labels and choosing the required categories 41 00:04:05,500 --> 00:04:06,370 are data cities 42 00:04:10,270 --> 00:04:18,030 you can see it I know I have only two customers I can choose another one like home space it 43 00:04:22,060 --> 00:04:30,190 and you really get to do it as it is now if I want to have a graph of all the months 44 00:04:34,530 --> 00:04:36,170 and you get a graph of all the month 45 00:04:38,970 --> 00:04:46,830 if you want to apply a finger on region you can select the Northeast region and then click on okay to 46 00:04:46,830 --> 00:04:56,790 get the values for Northeast region only point to North it is whatever change we do in this it is reflected 47 00:04:56,790 --> 00:05:04,140 in this table that is when I included other months those other months data values is shown here. 48 00:05:05,190 --> 00:05:13,020 Similarly if I change anything in the table it will be reflected in the chart so if I am moving January 49 00:05:13,020 --> 00:05:17,990 and fed from this table that will be removed from this chart also. 50 00:05:18,300 --> 00:05:23,340 So there is a two way link between a pivot table and a pivot jog. 51 00:05:24,210 --> 00:05:29,040 However if you believe this pivot table it will not delete this chart. 52 00:05:29,070 --> 00:05:32,350 This chart has its own individual identity. 53 00:05:32,910 --> 00:05:38,010 It will still continue to exist with all these debt options still remaining 54 00:05:41,180 --> 00:05:47,390 also note that there is an option of creating slices which probably you would be doing if you do not 55 00:05:47,390 --> 00:05:47,930 know. 56 00:05:48,360 --> 00:05:52,990 If I do that then we do tonight I told you about earlier too. 57 00:05:53,040 --> 00:05:54,300 If you have slices it 58 00:05:59,830 --> 00:06:02,450 for example if I just laser for the region 59 00:06:05,370 --> 00:06:07,480 and I have not selected here. 60 00:06:07,710 --> 00:06:14,740 If I click on Northwest this table and this chart both will show the data for Northwest. 61 00:06:14,740 --> 00:06:19,030 That is a slicer will work for both the table and arm 62 00:06:26,860 --> 00:06:31,080 so let us know learn how to create this chart when we have display table. 63 00:06:35,860 --> 00:06:37,540 Click anywhere on the pivot table 64 00:06:42,300 --> 00:06:45,440 go to inside and click on the weight chart. 65 00:06:48,610 --> 00:06:51,300 So here you'll get all the options. 66 00:06:51,340 --> 00:06:54,930 The first one is a clustered column chart which is what we drew. 67 00:06:54,970 --> 00:07:02,170 If you want to draw any other chart you can select that also and this is the big jacked that we had 68 00:07:02,550 --> 00:07:04,870 with all the different rendering options 69 00:07:07,930 --> 00:07:13,700 so if your data has a lot of cards and you would like to show different scenarios all combinations of 70 00:07:13,700 --> 00:07:20,360 data cities and categories in your presentation maybe creating 10 or 12 different charts will not help 71 00:07:21,170 --> 00:07:22,100 creating this one. 72 00:07:22,140 --> 00:07:31,220 Richard and using its photos to show all those light presenting maybe a better option. 73 00:07:31,380 --> 00:07:33,370 So it's a very strong chart. 74 00:07:33,690 --> 00:07:38,610 Whenever you are summarizing the data using a pivot table you can always use a pivot chart along with 75 00:07:38,610 --> 00:07:42,510 it to graphical e.g. plane did pivot table data.