this video is going to talk about charts
in Excel so last week we created a
spreadsheet that looks something like
this we've entered in some information
and we've also formatted it if anybody
doesn't have this done I'm gonna put a
link to this file so you can use this as
a starting point for today's class so in
here we have some information about some
supplies that we're going to order and
one of the things you often want to do
with Excel is to do something with your
information to either make it look more
visual or easier to read or just more
meaningful in some way so charts are one
of the ways that you can do that so we
are going to create a chart to kind of
show you know what the different
quantities are you know so we get an
idea of which ones we're ordering the
most and so on you add charts in Excel
on the insert menu so we'll go to that
next and you'll see there's a whole
section here to do with charts before
you click any of these options though
the the easiest way to create a chart is
to select the information that you want
to be on the chart first before you go
and kind of click anything on the menu
so we are going to highlight everything
from here so click on the very first
cell, right in the middle of it, drag
all the way down and then move your
mouse across as well so you're aiming to
kind of highlight all of this
information here all the quantities for
the products but also the names of the
products as well because then they'll
show up on the chart too okay so once
you have everything highlighted then you
can go up here and there is a small icon
for each different type of chart but
this recommended charts option will just
show you a kind of a pop-up box with all
the charts in it so we're going to go to
that
and it's given us a few recommendations
here bar charts and and so on but you
can also see all charts so we're gonna
go to that now just to kind of talk
about all the different types of charts
that Excel has so down the left hand
side here you'll see loads of different
options like column chart line pie and
we're gonna try a few of those now today
there's also a bar chart which is the
same as a column chart but
horizontal bars instead of vertical bars
there's loads of other options then as
well which you probably won't need to
use really the most common ones I think
are the first few that are up here
within each of those then you'll see
when you click on each one it gives you
a sort of a preview of what it's going
to look like and also a few different
options across the top for how it should
look so for this information we're gonna
just use a column chart and I'll just
leave it as the first type there cluster
column within that then there's two
options for how it can look so this is
one if you roll your mouse over it this
is gonna kind of give you a preview of
what that chart would look like so
that's that's that one then we also have
this option and I think I'm gonna go for
the first of those two okay so I'm gonna
click that you can see it's highlighted
now with a gray box around the edge so
that's that's my selected choice and
then click OK so that chart then should
appear and you can move the chart around
by kind of rolling over it anywhere in
sort of in the white space of the chart
and just click and drag to
move okay so we'll just move that so
it's sort of next to the information as
opposed to over it so you'll see there
it's picked up the quantities and it's
representing them as these bars it's
also because we highlighted the names of
the products it's also picked those up
as well so those are shown up at the
bottom once you have your chart and
there's a bunch of different things that
you can do with it so when you click on
a chart you will see this
char tools menu here appear okay so
there's a design menu and format menu
you'll notice by the way if you click
away from the chart those disappear so
you just need to click on the chart
again to get them to come back up so in
terms of design there's a whole lot of
different things you can do on this menu
here you can do things like change
colors so yeah actually when it when you
only have one type of information you'll
see you don't really have one color but
we'll see that the color is kind of
maybe come into play more a bit on the
other charts that we'll have a look at
in a second there's also chart Styles
here so these are kind of like quick
styles for your charts and they do
things like background colors and
I'm gonna pick this one so you see a
preview when you roll over them to
select one then you actually click on it
so when I've clicked on that now that's
applied those changes yes so this
one's got loads of stuff like
shadows in the background of the bars
and lots of nice things like that and so
yeah so those are got like quick styles
for the chart you can also do things on
the design menu like switch the rows and
the columns that doesn't make sense in
this case but for some types of
information that might work okay you can
also select data so just to show you
this is kind of handy to know if you
ever selected the wrong information if
you click on select data you'll be able
to go back and highlight again the
correct information that you did want to
select so you can do that as well okay
and you can also change the chart type
here if you need to if you think that
that's actually not working too well I
can go in and change it to maybe a bar
instead
yeah and that actually does look quite
nice so we'll stick with that one okay
under format then there's also more kind
of specific options like you can you can
change the colors of the bars and and do
loads of other stuff in there so yes you
can maybe have a play around with the
format menu yourselves one last thing
then that I did want to draw your
attention to with
chart is adding different chart elements
and so if you go back to the chart tools
design menu add chart element is the
very first option on that menu and in
there then there's loads of different
options for how you're supposed to like
the extra information that you're going
to display on the chart so this is
including things like the chart title
which you can see obviously we do have
one data labels which are the little
bars that kind of show up on the in this
case on the end of the bars we can do
things like add gridlines add a legend
and so on so I'm just gonna try out a
few of those options now chart title
first of all since we already have it
there we can change data to none or
above chart which is the current option
or overlaid on the chart but I'm gonna
leave it as it is I think that was
actually a good choice so above chart we
can obviously then also change it to
something that's kind of meaningful to
our charts so you click into it
highlight what's there and press
backspace or delete on your keyboard to
get rid of that and you can type your
own title in there then so I'm going to
call it quantity orders or something
something like that quantity
ordered 
some other things I might want to add to
this chart like by selecting the chart
style it's already added data labels and
so on so I might just add yeah maybe
grid lines or something else just to
show you that so gridlines are just
extra lines that you can add to your
chart well I've looked at a couple of
the other chart elements in the next
couple of examples that I'm going to
show you but that's that's essentially
yeah adding that chart okay um so in
excel we often have a number of
different sheets so last week we just
worked with one sheet you might notice
it down here there is a couple of other
sheets so there's normally I think three
sheets when you start a new blank
workbook
so as you can see I have some more
information on sheets 2 and 3
as well and you can have as
many of these different sheets within
the same file as you want if you don't
have any extra sheets you can add more
by clicking this plus button so I can
add an extra one here and I can also
rename them then by clicking on them so
if I double click on sheet1 here I can
change this one to be order sheets or
something like that so I know then by
looking at that sheet that you know
that's the the stuff to do with the
order and this one here I'm going to
just show you an example of some grades
so you can try this out yourselves if
you want you don't necessarily have to
there's an exercise to do that has some
other things for you to do but you can
try this one out yourselves if you want
so with these grades here I'm just gonna
show you an example of a pie chart ok so
again I'm gonna highlight all the
information that I want to include on
the chart so in here I'm going to go to
insert recommended charts and it is
actually recommending a pie chart so I'm
just gonna click that click OK and so
this is a pie chart
on here then I can do things like
we did before
add some maybe chart titles and
sometimes yeah if you're adding a chart
title you might need to right-click
and go to edit text to be able to
actually add the text in there call that
grades we can add a legend so legends
become more useful when you have a few
categories of information and so in this
case you can choose where you're gonna
put a right top left or bottom I'm gonna
just go with right so this is going to
tell us then which color relates to
which different grade so the A's are
blue the B's are red and so on and then
data labels just to show you how to add
those since with the other one we you
know the chart Styles bit kind of did it
for us with data labels you can choose
exactly where you want them to show up
okay so either outside at the end inside
at the end in the center or wherever you
think they look best okay and quickly
then I'm just gonna also show you a line
chart okay so actually now I'm
gonna call that sales instead so this
one as you can see is sales and its
sales in a few different regions over a
few different years so for this one I'll
go to recommended charts again and
it's actually just recommending either
bar or column but I'm gonna go to all
charts and select line and then choose
so within the line there's there's a few
different options I'm just gonna go with
the first one there and click okay so
this this type of chart is a good option
if you have information that's kind of
ongoing over time it's good one for
showing that kind of trends over time I
suppose with the chart by the way if you
have extra space you can resize them so
if you roll over one of the
or dots there you'll see you can click
and drag to make your charts a little
bit bigger okay um so this is actually
it's done a really good job of picking
up like my years it shows my years in
the legend and it also has my
different regions across here this is
maybe a case where I would want to
switch the row in the column so I
probably want the like the waterford
sales carlow and and each of those to be the different lines and the years to be kind
of the timeline if that makes sense
so it's shown over 2017 for example
waterfords you know the sales went up a bit in 2018 and down a bit in
2019 okay and lastly with that one I
might just add a chart title as well
okay so that's an example of three
different types of charts so we've seen
there a column and bar as well because
we switched a bar those are very similar
to one another we've seen a pie chart
and also a line chart as well so those
are all kind of that the most common
ones and also you know the most common
things you might want to do with them
like changing the colors the chart
styles and adding the different elements
so you can work away now on the exercise
that's there to just kind of explain
what you need to do you're going to
start off with the order spreadsheet
which is this sheet and like I said
if you don't have that file you can
download that file as a starting point
you're going to add a new sheet and you
can call that chart one and then type in
this information into it and then you're
going to create a chart from that a
column chart
okay so again you know highlight all the
information first and then create your
column chart it's also asking you to add
some specific labels and a chart title
and so on and there's another couple of
ones for you to try as well so you're
gonna add another
for this one enter this information and
create a chart and I'll just let you
choose yourselves what kind of charts
you think is best for that information
and lastly then this information so
again add another sheet type in this
information and then you can create a
chart from that as well so just practice
yourselves with charts try out all the
different settings that that I showed in
this video yeah and I hope you get on
okay with it
