In this video we will learn how to create a pivot chart
which charts a graphical representation of a picnic table.
If you know about what pivot 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 cities is about pivot tables.
That lecture was part of it.
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 summarize the data
in the form of rows and columns and give the corresponding counting sums or different combination of
categories.
So for example in this table I have little furniture sales.
The first column is giving me this sales person 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 sales person whenever he is selling any particular product that transaction is noted down into
this table.
If I want to get the total number of chairs sold by salesperson Well I can do that by using these filters
and setting that as 6 percent will
and then I can add the total cost of the number of items which are what I want to get the total number
of chairs sold by salesperson so this is a very lengthy process.
Also if I want to compare the JSE is by each individual salesperson that becomes even more Lindy.
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 corresponding with a chart so as you can see since I had the rule labels on the left.
These rule labels are coming as the horizontal axis labeled in this chart.
These two series that is the two names of our customers is the two cities plotted here and on the y
axis.
I am getting the value of total cost for each customer.
Apart from that I have added a freighter which is for region although I have not selected any region.
Same is depicted in this graph.
There is a free debt of region but there is no particular region selected.
So as you can see the difference between a normal bar graph and a pyramid bar graph is that you get
all these options of data of choosing the required axis labels and choosing the required categories
are data cities
you can see it I know I have only two customers I can choose another one like home space it
and you really get to do it as it is now if I want to have a graph of all the months
and you get a graph of all the month
if you want to apply a finger on region you can select the Northeast region and then click on okay to
get the values for Northeast region only point to North it is whatever change we do in this it is reflected
in this table that is when I included other months those other months data values is shown here.
Similarly if I change anything in the table it will be reflected in the chart so if I am moving January
and fed from this table that will be removed from this chart also.
So there is a two way link between a pivot table and a pivot jog.
However if you believe this pivot table it will not delete this chart.
This chart has its own individual identity.
It will still continue to exist with all these debt options still remaining
also note that there is an option of creating slices which probably you would be doing if you do not
know.
If I do that then we do tonight I told you about earlier too.
If you have slices it
for example if I just laser for the region
and I have not selected here.
If I click on Northwest this table and this chart both will show the data for Northwest.
That is a slicer will work for both the table and arm
so let us know learn how to create this chart when we have display table.
Click anywhere on the pivot table
go to inside and click on the weight chart.
So here you'll get all the options.
The first one is a clustered column chart which is what we drew.
If you want to draw any other chart you can select that also and this is the big jacked that we had
with all the different rendering options
so if your data has a lot of cards and you would like to show different scenarios all combinations of
data cities and categories in your presentation maybe creating 10 or 12 different charts will not help
creating this one.
Richard and using its photos to show all those light presenting maybe a better option.
So it's a very strong chart.
Whenever you are summarizing the data using a pivot table you can always use a pivot chart along with
it to graphical e.g. plane did pivot table data.