6 hours 3 minutes
this lesson. I'm going to talk about creating charts, and this is one of the most important thinking Excel, because excels is mostly used for some kind of business application
and in business application, especially if you're doing some financial presentation or some analysis. Charts are the most important way to present data, because just looking at the numbers is usually way too boring and hard to understand. So charts make things
more understandable and make numbers more appealing.
So imagine we have something like this, and this is some kind of annual sales report of your company, and you just see some numbers on there not even formatted,
but for our purpose. Here doesn't matter.
And if you look at these numbers, you see pretty much nothing.
So, for example,
you want to create the simple chart
with just months and revenue in
generated by products.
So you'll go to insert Tab. You click here, and then you have a typical chart that is used all the time so you can click here
and you get this chart. And now you can do things with this chart. Um,
you can ah,
of course, do all the things you can
do with the objects that existed in Excel. So, for example, you can
make it like this because you,
for some reasons, wants to put more charges in this one
on on your sheet. So this is just the revenue in products
on this is just giving you the idea. What is the revenue products?
And also, you can click here
and you can, ah,
area So you can you can make a pattern feel
like this, which you probably don't want,
or you can have a Grady and Phil, which makes things much nicer.
now, this looks like
very, very nice
information, visual information that somebody can
did you something out of it. And of course you want it like this so that these things would be much reason more visible.
Now, what you can do here is you can also change,
this type of chart which will give you these numbers here.
Now, this is not very readable. But if you
for example increased this
and then go to text options and put the color to be
black, for example, this is a little bit more readable, so you can also do this. And instead of having a vertical axis here, you can see just the numbers and you can see the trends how these things change.
Well, let's move this away a little bit and go for further possibility of creating charts, can you? Now,
you need to put more
then just one
line on this chart. So we would go again to insert,
and then we can choose a different type of chart.
For example, um,
we can use this
which is ah
to the column chart. In Richer. We would have revenue of products on DDE
Service's and financial one next to each other,
but this is not very visible.
So what I would recommend in this case
is to use something like this,
something like this.
Now, you don't see things from this one,
you get this, so you go to select data
and then you want financial Toby on top,
and then service is to be second.
And now we Sorry.
And now you see
everything in three D in much nicer view.
let's remove this one as well.
What is mostly recommended for this type of
is to go here
and to have this stack.
And in this case,
this is stacked. So the Williams air stacked one off on top of each other.
But what you see here is
the combined. So you see the total revenue as well,
because some of these three represents total revenue. If you look at here
total revenue, simply that some of these three
so you can use this.
And now you can see not only just friends
from month to month
back, and you can also see the trends off
each one of these.
So these are very, very nice
to display charts or
which just moved this one.
Or you can go for total. So you want everything to be displayed in one chart
and you go again to insert,
and you can, uh,
You can do it in three D
or to the
or you can just use
lines like this with markers so that some things are reasonable, much more
or you can use decline. But this is not exactly the the good. So this one
is really, really showing you everything that is happening. So you're seeing every
part of this so you can see the margin is dropping down and up and you see it in absolute values
and you see everything like you want.
So whoever reads this and they know
they can do it now you made a mistake and say, OK, I made a mistake. I want to change the
so you can Ah, for example, go to this one
and you want to avoid lines because there is too much information there
and you get this. Now again, this is not really something that you would need views for.
It's financial information,
but you can go to this type of chart as well. And then it would give you all the information. Here again, it is something that you have to choose based on your audience and how they look at the data. You can also switch row in column
so you can have revenue products by month and then your revenue service's by month and revenue horizontal, the financial by month and rever total revenue by month and gross margin by month. So you
this trending here for each and every
component off your report.
Andi, you can hear change some styles. You can make it, uh
uh, semi transparent.
Or you can make it like this
something like this. So
again, possibilities with graphics representation station is infinite. I will no longer go into details because you can really influence these things a lot. You can change colors
s so you can make it like, monochromatic.
So it doesn't, uh,
bother you too much with colors on dhe. Then you can
do something like this or
something like this.
And this is much more
appealing to the eye and doesn't distract you with all these colors from the main point, which is to see the trends in all these perimeters off business.
So this is all about inserting charts? There's quite a lot. But for this level, of course, I think that this is enough.