In this video, we will learn how to create a pivot chart,
which charts a graphical representation of a pivot table if you know about what the tables are and how
to use them.
You can continue with this lecture if you do not know about pivot tables.
The next lecture in the series is about pivot tables.
That lecture was part of another course on Microsoft Excel.
We have included here so that you can learn about pivot tables.
If you want to learn more about other such features of Microsoft Excel, you can enroll in another course
of Excel Master Class.
So Pivot tables basically summarized data in the form of rules and columns and give the corresponding
accounts and sums of different combinations of categories.
So, for example, in this table, I have data of furniture sales.
The first column is giving me the salesperson.
The next column tells me what product that salesperson sold next column is, which region does that
salesperson belong?
Then we get the name of the customer, then is the date of sale.
Then we have the item cost.
Then we have the number of items sold and then we have the total cost.
So I have all these transactions, so every salesperson, whenever he is selling any particular product,
that transaction is not returning into the table.
If I want to get the total number of shares sold by six percent.
Well, I can do that by using these filters.
And think that is six percent, 12.
And then I can add the total cost or the number of items, whichever I want to get the total number
of shares sold by a salesperson.
So this is a very lengthy process, also, if I want to compare the two years held by each individual
salesperson, that becomes even more lendee.
This is where summarizing the data using a pivot table helps us turn the next sheet.
You can see on the left is a pivot table, which can summarize the data as I want it to be corresponding
to this table, I can draw a corresponding pivot chart.
So as you can see, since I had roll labeled on the left, these roll labels are coming as the horizontal
axis labels in this chart.
These two cities, that is the two names of our customers is the two cities plotted here.
And on the Y-axis axis, I'm getting the value of.
Total cost for each customer.
Apart from that, I have added a filter, which is what region, although I have not selected any region,
same as depicted in this graph, there is a filter of region, but there is no particular region selected.
So as you can see, the difference between a normal bar graph and a pivot bar graph is that you get
all these options of filter.
Of choosing the required axis labels and choosing the required categories or datasets.
You can see right now, I have only two customers I can choose another one like home space here.
And you will get treated as it is, no.
If I want to have a graph of Aldermen's.
He's got a graph of all the money to.
If you want to apply to your own region, we can select the Northeast region and then click on OK to
get the values for Northeast region only a point to note here is whatever change we do in this chart
is reflected in this table that is included other months, those other months, data values as shown
here.
Similarly, if I change anything in the table, it will be reflected in the chart.
So if I'm moving January and February from the table.
That will be removed from this chart also, so there is a two way link between a pivot table and a pivot
chart.
However, if you believe this pivot table, it will not be discharged.
This chart has its own individual identity.
It will still continue to exist with all these other options still remaining.
Also note that there is an option of creating slicers, which probably would be annoying if you do not
know the answer to that either.
We do know that I told you about earlier.
So if you have slicers here.
For example, if I had a laser for region.
And I have not selected her if I click on NW.
This table and this chart both will show the data for Notwist, that is a slotter will work for both
the table and Richard.
So let us now learn how to create this chart when we have this table.
Click anywhere on the political.
Go to insert and click on to a chart.
So here you'll get all the options, the first one is a cluster column chart, which is what we do.
If you want to draw any other chart, you can select that also.
And this is the big picture that we had with all the different filtering options.
So if your data has a lot of cards and you would like to show different scenarios or combinations of
datasets and categories in your presentation, maybe creating 10 or 12 different charts will not help
creating this one.
Richard?
And using its filters to show all those representing may be a better option, so it's a very strong
charge.
Whenever you are summarizing the data using a pivot table, you can always use a pivot chart along with
it to graphically represent the political leader.