6 hours 3 minutes
in this video, you will be able to see how to do the labs for Model seven
on DA again. As before, I strongly suggest that you tried to do this slabs by yourself without looking at this video or
look at this video are used. The instructions is help on Lee. If you can do it by yourself or you don't understand what the task is and you want to see what is actually required of you.
So let's go directly to the Excel Sheet, which represents them labs.
And here we have some,
um, revenue report from ah company for entire year. And we haven't divided in three Sorry, 4/4.
And so we have ends up, especially for all of the months. So we have revenue
from products. Revenue from service is revenue from financial service is we have total revenue
and we have gross margin, and we want to create some kind of charge that will we need to create. This is the idea of the slabs
is to create
five charts in the 1st 1 You will
Ah, 1st 1 has to show.
Ah, what is the distribution off
all these financial perimeters per month during entire year.
So in order to do that, we're going to select this without the quarters because that would be additional information for Excel to process, and
it will get confused.
So let's go to insert, let's go to recommend the charts.
And then let's take on all charts
and we're going to select this one
because this one will show separately
for every month. Revenue Products Revenue Service is there in the financial service is total revenue and gross margin in separate groups,
and this is what we're supposed to do. So we're going to just click here,
and then we're going to drag it here and make it little bit bigger. So it should be almost as wide as the table itself.
And then we're going to change colors because this is it. One. We wanted to be monochromatic. We don't need this monthly coloring
because we know that the 1st 1 is January, February, March. So it's it doesn't help
toe understand anything here
by using this. So we're going to click here, and this is what was expected of us. So to create monochromatic calm chart Ah,
with revenue products roaming service is rare in a financial service is total ruin you and gross margin grouped
together for entire year.
Next step would be
for each quarter. So
and we want sticked combs
in which we're going to see just revenue,
all the revenues
and this The stack is going to represent the total revenue because to some off these three you see here on the screen.
So we're going to go again to insert
you're going to go to recommend the charts.
Let's go to old charts are here. We have it. So we have a stacked column
and this is exactly what we wanted.
So the colors
types of revenues, and then you look at the total height of this con.
It represents the
total revenue because it's it's some of the history.
So we have to create these for four
and so in the next one,
we're just going to click on the edge of this chart. We're goingto press control and shift,
and this will do the copy off this one while we drag it
and keep it in the same horizontal level as the previous one.
So now it's also January February March, and we wanted to be for next quarter.
So what are we going to do?
Let me just make this a little bit smaller so we can see everything.
We're going to click again on the edge, right click
and goes to select data.
And now first we're going to edit day town horizontal exes
so it's no longer going. Toe becomes be true. The it's going to be e through g.
So here, instead of B, we're going to put E instead of D.
We're going to put G with. Okay, now, here, April, May June. But the
the values are going to stay the same unless we edit them so weakly connected series
in Syria's values
again we go e
and we click. And now it's changed. So it's now Actually, the values for April and May in June
again was just like okay,
again, we're going to click on the edge of this chart
movie 12 pressing control shift. So it's now going to be moved vertically.
Dragon drop. You released the mouse button
and we go through the same procedure. So we see like data
here we change. Now it's going to be a judge
And here again,
age through J
and the K. And now we have
July through September.
And then again,
control, shift and drag.
And we have here now
a copy of this one.
so like data. We go here.
So it's now going to be
and here also
And now we have completed
so let's zoom out a little bit more.
So you see, we have data here.
We have total charts for
business operations. So revenue products revenue Service's room in a financial and total revenue and gross margin for each of the month so we can see the trends off each changing in time during in a year.
And then here we have separately for each quarter, just the revenues. So we have
revenue products, revenue service's revenue, financial, and the total height of the bar represents
total revenue for each month within the quarter. What we can do here, for example, is go to this chart here
and just change.
So we take kyu won
and here we go go inside the text, select all the text and change it with cute, too.
Here again. So we click on this small box textbooks, which represents the title off the track.
We so like the text and press Q three
And that is the end of this labs. So now everything is clear. Whoever looks at it,
we understand what it is all about. Everything is nicely labelled
known numbers overlapping, no
hard to see details. Everything is quite clear. Everything is visible and nicely graphically represented.