1
00:00:01,940 --> 00:00:04,880
In this video, we will learn how to create a pivot chart,

2
00:00:07,880 --> 00:00:16,130
which charts a graphical representation of a pivot table if you know about what the tables are and how

3
00:00:16,130 --> 00:00:16,790
to use them.

4
00:00:18,200 --> 00:00:22,450
You can continue with this lecture if you do not know about pivot tables.

5
00:00:22,820 --> 00:00:25,860
The next lecture in the series is about pivot tables.

6
00:00:27,350 --> 00:00:30,760
That lecture was part of another course on Microsoft Excel.

7
00:00:31,640 --> 00:00:35,240
We have included here so that you can learn about pivot tables.

8
00:00:36,320 --> 00:00:43,970
If you want to learn more about other such features of Microsoft Excel, you can enroll in another course

9
00:00:44,690 --> 00:00:46,160
of Excel Master Class.

10
00:00:48,430 --> 00:00:55,210
So Pivot tables basically summarized data in the form of rules and columns and give the corresponding

11
00:00:55,420 --> 00:00:58,930
accounts and sums of different combinations of categories.

12
00:00:59,920 --> 00:01:05,260
So, for example, in this table, I have data of furniture sales.

13
00:01:05,700 --> 00:01:08,320
The first column is giving me the salesperson.

14
00:01:11,020 --> 00:01:19,480
The next column tells me what product that salesperson sold next column is, which region does that

15
00:01:19,480 --> 00:01:20,510
salesperson belong?

16
00:01:22,150 --> 00:01:27,070
Then we get the name of the customer, then is the date of sale.

17
00:01:28,210 --> 00:01:29,820
Then we have the item cost.

18
00:01:30,700 --> 00:01:34,030
Then we have the number of items sold and then we have the total cost.

19
00:01:35,430 --> 00:01:42,900
So I have all these transactions, so every salesperson, whenever he is selling any particular product,

20
00:01:43,590 --> 00:01:46,140
that transaction is not returning into the table.

21
00:01:47,340 --> 00:01:53,190
If I want to get the total number of shares sold by six percent.

22
00:01:53,360 --> 00:01:57,720
Well, I can do that by using these filters.

23
00:02:02,610 --> 00:02:04,740
And think that is six percent, 12.

24
00:02:07,810 --> 00:02:19,120
And then I can add the total cost or the number of items, whichever I want to get the total number

25
00:02:19,120 --> 00:02:20,860
of shares sold by a salesperson.

26
00:02:23,100 --> 00:02:30,270
So this is a very lengthy process, also, if I want to compare the two years held by each individual

27
00:02:30,270 --> 00:02:32,930
salesperson, that becomes even more lendee.

28
00:02:33,810 --> 00:02:39,510
This is where summarizing the data using a pivot table helps us turn the next sheet.

29
00:02:41,220 --> 00:02:50,010
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:50,010 --> 00:02:54,300
to this table, I can draw a corresponding pivot chart.

31
00:02:56,520 --> 00:03:05,700
So as you can see, since I had roll labeled on the left, these roll labels are coming as the horizontal

32
00:03:05,700 --> 00:03:07,560
axis labels in this chart.

33
00:03:09,430 --> 00:03:17,440
These two cities, that is the two names of our customers is the two cities plotted here.

34
00:03:19,850 --> 00:03:23,150
And on the Y-axis axis, I'm getting the value of.

35
00:03:25,110 --> 00:03:27,330
Total cost for each customer.

36
00:03:30,330 --> 00:03:36,890
Apart from that, I have added a filter, which is what region, although I have not selected any region,

37
00:03:37,620 --> 00:03:44,730
same as depicted in this graph, there is a filter of region, but there is no particular region selected.

38
00:03:46,230 --> 00:03:53,550
So as you can see, the difference between a normal bar graph and a pivot bar graph is that you get

39
00:03:53,700 --> 00:03:56,130
all these options of filter.

40
00:03:57,930 --> 00:04:06,360
Of choosing the required axis labels and choosing the required categories or datasets.

41
00:04:10,160 --> 00:04:18,080
You can see right now, I have only two customers I can choose another one like home space here.

42
00:04:21,910 --> 00:04:24,730
And you will get treated as it is, no.

43
00:04:26,370 --> 00:04:30,180
If I want to have a graph of Aldermen's.

44
00:04:34,500 --> 00:04:36,260
He's got a graph of all the money to.

45
00:04:38,890 --> 00:04:46,840
If you want to apply to your own region, we can select the Northeast region and then click on OK to

46
00:04:46,840 --> 00:04:55,510
get the values for Northeast region only a point to note here is whatever change we do in this chart

47
00:04:56,020 --> 00:05:03,880
is reflected in this table that is included other months, those other months, data values as shown

48
00:05:03,880 --> 00:05:04,130
here.

49
00:05:05,140 --> 00:05:11,230
Similarly, if I change anything in the table, it will be reflected in the chart.

50
00:05:11,380 --> 00:05:14,500
So if I'm moving January and February from the table.

51
00:05:15,970 --> 00:05:22,660
That will be removed from this chart also, so there is a two way link between a pivot table and a pivot

52
00:05:22,660 --> 00:05:23,050
chart.

53
00:05:24,130 --> 00:05:28,760
However, if you believe this pivot table, it will not be discharged.

54
00:05:29,020 --> 00:05:31,670
This chart has its own individual identity.

55
00:05:32,800 --> 00:05:38,020
It will still continue to exist with all these other options still remaining.

56
00:05:41,060 --> 00:05:47,390
Also note that there is an option of creating slicers, which probably would be annoying if you do not

57
00:05:47,390 --> 00:05:49,220
know the answer to that either.

58
00:05:49,240 --> 00:05:50,800
We do know that I told you about earlier.

59
00:05:52,730 --> 00:05:54,320
So if you have slicers here.

60
00:06:00,050 --> 00:06:02,450
For example, if I had a laser for region.

61
00:06:05,250 --> 00:06:08,880
And I have not selected her if I click on NW.

62
00:06:10,000 --> 00:06:17,530
This table and this chart both will show the data for Notwist, that is a slotter will work for both

63
00:06:17,770 --> 00:06:19,120
the table and Richard.

64
00:06:26,800 --> 00:06:31,090
So let us now learn how to create this chart when we have this table.

65
00:06:35,840 --> 00:06:37,550
Click anywhere on the political.

66
00:06:42,250 --> 00:06:44,500
Go to insert and click on to a chart.

67
00:06:48,550 --> 00:06:54,670
So here you'll get all the options, the first one is a cluster column chart, which is what we do.

68
00:06:54,880 --> 00:06:57,700
If you want to draw any other chart, you can select that also.

69
00:06:59,380 --> 00:07:04,900
And this is the big picture that we had with all the different filtering options.

70
00:07:07,880 --> 00:07:13,700
So if your data has a lot of cards and you would like to show different scenarios or combinations of

71
00:07:13,700 --> 00:07:20,390
datasets and categories in your presentation, maybe creating 10 or 12 different charts will not help

72
00:07:21,110 --> 00:07:21,980
creating this one.

73
00:07:22,130 --> 00:07:22,670
Richard?

74
00:07:24,690 --> 00:07:32,670
And using its filters to show all those representing may be a better option, so it's a very strong

75
00:07:32,670 --> 00:07:33,030
charge.

76
00:07:33,600 --> 00:07:38,600
Whenever you are summarizing the data using a pivot table, you can always use a pivot chart along with

77
00:07:38,610 --> 00:07:42,560
it to graphically represent the political leader.