Hey guys in this video, I'm going to
show you how to take your information in
Excel that's listed on your
worksheet.  These were just typed in
nothing fancy, no formulas. I selected a
cell type plain information in and I'll show
you how to take this information and to
put it into a chart.  So you would just
select, I clicked once at the top, I'm
going to select all the information that
I want to go into my chart.  I've selected
it.  To insert a chart on to my excel
sheet I'm going to go to the insert tab.
Here you'll see in the chart family
there are different types of charts that
you can use.  For this this situation I
want to see a visual representation of
how many drawstring bags, for example, I
have out of my whole inventory.  So this
will show me a quick snapshot of how
much I have of that.  So here we go, I
believe in the assignment it's similar
this for you guys you're mm and skittles
you're told to use the exploded pie in
3D so that's the one we're going to use
for this.  If you hover over the
little icons it will show you what kind
of chart each of these things are; so for
this again when using exploded pie.
All I did was select and then I
clicked on the current, oops I'm sorry, I click on
that exploded pie in 3d.  This isn't all
of my stuff, so I can see I have all the
colors and all the wedge is on there but
I only see a few of my items, so I'm going
to make this as big as I can because
I've got a lot of items listed must
stretch it out.  I've stretched a
little too far and so until here is my
pie chart and here are my my items see
until I have all of them because it
starts at the 1/2 White Binder and ends
at water.  I can change the color of my
wedges so I can tell that this item this
teal is the largest piece of my pie.  I
can match it over here and see that it
says Motts Fruit Snacks but those are the
ones I had the most stuff.  Maybe I want
this to be a different color so I would
click on it and you see I has a little
dot set up here on the corners of my
wedges let me go up to the chart tools
and format because I
to change the color.  You can click on
shape fill and choose any one of these
colors that you like, so I'm going to go
with this yellow.  You'll see it changed my
wedge color and it changed the little
key color here.  So you could go through
and do that for each item to ensure the
easiest quick shot visibility.  So hope
that helped!  Let me know if you have
questions  :)
