in this tutorial we're going to look at
making
a pie chart and to do that I made up
a sample of fictitious people's
favorite pies and apple...
27 people picked Apple as their favorite
nine people pick cherry as their favorite
and...  this is a fictitious survey so...
it's not based on any real data.. now one we
to make the chart is we can highlight
all this data
but another thing is just like in our
sorting and groups that we've seen
before
I just highlight somewhere in there click
on my chart
it automatically selects this whole
group
for my data and it creates a column
chart
the first
thing that it asks us for, is the chart type
and thats column
to do a bar chart i click on the bar in
it shows me a little preview here
now I'm clicking to pie that's the one
that we want to work with
the pie chart so...
we're okay with that and i want to go to
the data range
and it's telling us that this is correct
if we didn't like this data range it in
selected properly
I can click this little select data
range and
then I would just highlight the area
that I want
and it grabs that now it asks is this the correct
data range we say yes
the data is in rows and the first row
is a label so were good with that
the data series will review that in the
next tutorial
and the chart elements... we will review
that in the next tutorial so we click
Finish
and now we have
our chart out there and it looks
kinda funny so I need to click
off it to make it set into the
sheet here.  OK,  we've clicked off the
chart
to set it  into the spreadsheet but if you
want going to make some edits we would click
on it again
and we've got these green
boxes around it which does so we can
move the chart itself
at this point or we can resize
just as we would if we had inserted a
picture into this
spreadsheet now to edit the chart itself
we need to
double click inside here any changes to
these gray lines
now with the gray lines we can edit the
typeof chart we have we've got a pie
chart
to change that I would click right on to the
chart I can change the chart type
to the bar come back to the pie
clicking OK now I'm gonna change the
color
of some of these because the Apple is blue
and the blueberries red
so let's try and change the blueberry to blue
so I select that section format it
to blue so now we got a blueberry blue
I will go into a key lime and make
this more of a key lime color
so we're gonna go up to
make this a bright green like this already... and
lemon meringue
its its yellow but let's see if we can
make a little brighter yellow
we have this yellow here - That's too yellow
how about yellow 2... okay
the next one is cherry we want to make
this one a red
and the last is
Apple and we wanna make this one a green
okay so now we've got
the colors matching up -  that is how we would change our
colors and if we want to change the
Font here we would  just right click and the format
legend here and
I can change the font to... It give you a little
sample down below of what it would look
like
we don't like that
and gothic...
let's just go with the
reference and serif may be you want to bold it
and clicking OK and then of course we
can move this around to... move it up
or down and let's put
title on here with their right click
and insert titles and for main title
we are just going to say pie
chart people's
favorite Pies
and we want to move this over a little bit to the right
now on our research we just had
more people come in... so I"m going to
change this number from 27 to 47 we
just had 20 more people
and the like the pie chart... they like
the Apple
so clicking on that it changes the chart
just by changing the data
so that's pretty cool.  now we have
more people liking cherry
I but we going to do the math so we see
nine plus
fourteen, 14 more people like that
whoops, I forgot to say equals...
equals nine plus 14 and there's our
cherry pie updated so that's
a quick review of how to.... oh one
more thing
for you people that have I am the higher
graphics cards
let's change this chart type... 
I'm double-clicking
and I need the gray area... there we go
changing the chart type.. we want to make this
the 3D look
now we've got the 3d if I click here where I have the red
I can alter it...   make it...
the sides here will go up and down
so you can have some fun with the 3d
here
with our chart type
think that with the red... what if I just
double click to the green thats to
resize it
it in here and then of course we get the
fou arrows you can move it around as you
like and stretch it
as a chart so fun stuff to play with
and to show your your data in a chart
all all cool all
