Today I'm going to demonstrate how to
create a pie chart. Unlike a column or
line chart, a pie chart can only plot one
data series. You're trying to
distribute parts of a whole. In this
example I'm going to show
the total annual number of house sales
by house. The range that we need to
select are not adjacent to each other. To select non-adjacent ranges of cells,
you begin by using the white
cross. Click, hold and select the first
range. I'm selecting cells A5 to A9. Hold your control key down (CTRL) and
select F5 to F9. Use your Insert ribbon,
pie chart. We'll make it a 3d pie chart.
By default your charts are embedded in
the worksheet. We can move them to their
own chart sheet by clicking the Design
ribbon, move chart, new sheet. We will
name this annual sales. The chart
instantly is removed from the initial
worksheet and placed on its own chart
sheet. We can change the title by
clicking in it and typing House Sales
for the Year.  With a chart, I'll zoom in a
little bit.
With the chart, we can -
instead of having a legend at the bottom,
we can remove the legend.
Then to identify the slices of the
pie of chart, we can add data labels. The
data labels that we can add are the
category names.  And instead of values, I'm going
to put percentages. 
Clicking on the pie chart, we have every
slice of the pie selected. You see the
little dot in each corner of the slice.
If you only want to select one slice, you
then click that slice again. Notice that
the sizing handles are only around that
slice. We can explode that slice. You can click
hold and drag it out or you could use
your the panel on the right hand side
and explode it. That's called exploding a
slice - you're really trying to emphasize
a particular slice. You can change the
first angle of the slice by rotating it
so many degrees. We can take the fill
color of this slice and add a nice
little gradient or maybe even a picture
or texture fill. I'll select
granite. You can see you can do that.
We can select the data points and make
them bold and let's make them a little
bit bigger,  more like 16 points.  You can see
them a little better. This is just
typical things that you can do with a
pie chart.
