This video is part 2 in a series of videos
on graphing in excel 2010.
Part 1 in this series was an introduction
to pie charts and bar graphs.
In this part I will step you through the process
of making one of the pie charts I used in
part 1.
On my excel spreadsheet I have the information
for the in state students tuition and fees.
To start a pie chart there are two main ways.
The first is to select your range of data,
go to insert, pie and choose one of the options
here.
I am going to choose this 2-D pie chart option.
It is the simplest one and it will represent
out data very well.
As you can see it already fills in the size
of the slices according to the numerical values
of our tuition and fees.
Another way to start a pie chart is if you
do not have a range of cells selected you
can still go to insert, pie and make your
selection.
It will just fill in an empty chart.
It tries to guess what your range will be
but as you can see here it is wrong.
What you can do instead of deleting this and
starting over is you can right click and go
to select data.
This is your data entry.
I am going to edit this and change the series
name from what it automatically selected as
"Pie Charts" to "In-State Tuition and Fees".
Then the series values instead of these two
cells here that it selected I am going to
delete that and reselect this range of cells
here.
As you can see it automatically filled in
the pie chart the way it had been previously
but the legend is still incorrect.
If I select ok the place I go to change the
legend is here at the horizontal axis.
I go to edit and the range of cells for the
axis labels or in our case just the legend
is right here because each of these corresponds
to the price value associated with it.
If I select ok and ok again you can see that
the legend has been filled in however there
are only six option on the legend and that
only goes to about here on our list.
This is an easy fix.
All you have to do is make your graph larger.
Since this graph is so large I am going to
go ahead and just move it to its own sheet.
If you right lick and go to move chart I am
going to choose the new sheet and label it
"In-State Pie Chart".
It moves it to a new sheet that is directly
before the one that has the price information.
As you can see here the pie chart is very
large but all of the text is rather small.
Before I change the size of the text I want
to label the pie chart slices.
I am going to expand the ribbon up here and
go to chart tools, layout and data labels.
These are the options to change the data labels
on the slices themselves.
For the label center, inside end and outside
end you have the same problem with all three
of them.
It will show up well for the three larger
slices but once you get to the smaller slices
the numbers all run together.
Instead I am going to select best fit.
This is where the computer tries to decide
where the best place is to put all of the
data labels to make it easier to read.
I am going to move the title over here to
make a little more room for the data labels.
Since they are so difficult to read I am going
to change their font size.
By clicking on one of them it automatically
selects all of them and I can right click
and change the font size to 14.
As you can see the numbers are much easier
to read.
I am going to go ahead and do that and change
the legend also to font 14 and change the
title to font 20.
Here it still has some overlap between the
slices so what I am going to do is move a
few of these manually to see if I can get
them to arrange themselves in a way that they
are easy to read.
It is not perfect but you can still tell which
slice everything corresponds to.
Also if you select one of these since these
three here that are on the slices have a dark
background and dark text I can select just
one by clicking on it again and then right
click and change the text color.
I am going to change it to white and now these
are much easier to read.
I can go through and do this for each of them.
I do not however want to change these to white
since it is on a white background.
There are other different design options you
can do.
If you go to design tab you can choose different
color schemes, you can have 3-D, or a black
background.
Some of these are very visually appealing
however if you are going to print it out keep
in mind that it may not print the exact same
way that it shows up on the screen.
Also if you choose one with a black background
you are going to use a lot of ink when you
are printing.
I am going to go ahead and leave this in the
same design that it automatically did.
Just by looking at this pie chart you can
see that there is a lot of information available.
The number on the pie chart slice corresponds
to its matching comparison value.
For example this blue slice corresponds to
tuition which is $12,650.
If I hover over the slice however some more
information is available.
For example here I can see that the series
is "In-State Tuition and Fees", the point
is tuition which is also the comparison value,
the value is $12,650 which is visual on the
slice itself and the extra information is
the fact that it takes up 45% of what is paid
for this student.
An in-state student pays only 45% of their
total fees in tuition as tuition alone.
