6 hours 3 minutes
in previous lesson, you have seen how to create people table
and this lesson. I'm going to explain to you how to use the table toe, create accompanying chart or to create something that is commonly known as paper chart.
So let's go directly to our
Excel sheet worksheet.
And here we have the original daytime. Let's create one,
table that will be useful for our explanation here. So let's go and create the people table. You'll use the same original source, and basically, I'm going to create here the same
shape off people table like I used when I started showing you the examples. So with a little difference, or we're going to add a month, the filters.
So we have all of this. And now we have all these numbers that represent how many successful resolutions of the case each of the
technicians head on and how many total resolutions, bridge class and so on. And so So this is it.
I'm staying in this, uh,
people table. It's important that you're somewhere within inside of it, so that self selected is within this
people table and you just go to people. Chart
and Did you choose the type off?
charge you want.
So it can be history. Grant Majority can't be hist a gram or some other things because they're not therefore pill tables. But you can use, for example, cluster cone,
which is a very reasonable
idea for this kind of
representation. So parents is going to choose this one,
and we get this. So we get ah, failure category here
and it zero
and we can we can now filter it so we can just say Okay, we don't want thes we just to see
what happens with
the successful region, the resolutions of the cases and you can see
how it looks
or and it automatically the
the things from the table as well are hidden. So this is some kind of dynamic track that you can use
to look at Dayton graphical way
and analyze them or you can go back. It takes a little time for excel toe Reedus plate.
And you could say, OK, I just want
Pablo and Tamara,
and I want to see how they compare
and who is better. So we have just those two and their total number of cases
we can do it separately for
and just December
Sorry, it takes time,
or we can go back to the cumulative
calculation for both months for which we have data.
So this is how you create the pivot chart,
and it's relatively simple
process, and depending on type of data, you might want to change the
type of chart you have so we can train, chart type,
say, Okay, let's go with lines
and sometimes lines. They're not the best thing to
but if you want to have all of them,
So this is, uh, this is not really showing this well, but I wanted to show you this because
the type of chartreuse is a very, very important for ah, what they were.
are you trying to show because in this stable, be actually, don't see
a lot, you have to stretch it in order to see something useful out of it, and even then,
it's not that clear.
But you can see the trends that there is quite a lot off successful attempts
on, and then it's dropping down. And actually those those that they're not resolved it all that the most difficult ones
relatively high compared to, for example, those in which it was almost sold but given to the higher level of support to something like that.
So, uh, we have this chart. Let's change it back to the more reasonable
charts type, which is
For example, if you choose pie chart, it makes absolutely no sense because you get it just for one.
Because by chart cannot show these complex things, bar chart may make sense.
So Clustered bar.
It also makes sense because then you see here
as well. If you wanted to be positioned vertically
so you can play with this, you can find whatever you
I want to do with it. But most important thing is to have meaningful data that can be
used in people table. There are some kind of data that
it's really difficult to use them in a pivot table.
So this is all about people charts,
and I'm going to give you one more complex example in labs for this module in which you would go with the same kind of sales report data, and it's going to give you much more opportunity to tinker with in terms off.
What do you want?
To be displayed off course. First, you should,
uh, fulfilled the task given in their laps.