In our previous video, we created a chart
and in this video we're going to take a look
at how you format that chart once you've got
it created.
Again, this is similar to Excel.
First of all, just click on the chart and
the handles will appear around it.
And we'll get these buttons over here and
let's click on Chart Elements.
And it lets us determine whether we want to
have a title or not.
We've got some options about where we want
to put it.
And that's probably not where we want it.
Let's look at some other options here.
And, we can give it a fill color and a border.
I don't think that's a big deal with a title.
This stuff is not really a big deal with a
title, either.
Nor is this.
You can mess with the alignment.
You can rotate a little bit.
But let's close that.
Let's go back here and go to our Chart Title
and click on our options and again let's just
put it above the chart.
I think that looks the best there.
Now if you don't like it there, you can get
the four-headed arrow
and you can pretty much move it anyplace you
want to anyway.
So I'm going to undo that to get it back so
it's centered over the top like that.
And let's go to our paintbrush here and this
gives us
some options for Styles and Colors.
So if I click a different color palette here...
And I really don't like monochromatic ones
at all because
they are basically different shades of the
same color.
And if you do have a legend, although you
frequently don't have
a legend with a pie chart, it just makes it
hard to read, you know.
You've got four shades of purple and you've
got to try to figure out
which shade of purple this is down here.
So I think you're better off with the Colorful
options up here.
And we'll just leave it with the original.
And then for Style here, and let's scroll
down a little bit further
and see what else we get for options.
And what I kind of like is one with everything
around
the edges but I would also like to have the
numbers.
I really don't like legends with pie charts
because
you have to go back and forth.
Now, there we go, but everything is the same
color and
it doesn't really look all that cool, either.
So let's just go back to our original here
and then
we've got an option over here for funneling
or filtering.
And if you don't want to see everything in
the chart,
you can turn some of it off, but I don't think
that's going
to happen very often.
If you don't want the data in the chart,
you probably just wouldn't select it in the
first place.
Now what I really want to have when I do a
pie chart
is I don't want to have the legend down here.
You can click on it, hit the Delete key and
make it go away,
but now you've got a totally worthless chart.
But if I right-click on the chart and go to
Add Data Labels and Add Data Labels here,
it'll put the
numbers there for me.
If I right-click again and I go to
Format Data Series...
That's not what I wanted.
I wanted Format Data Labels, and here we go.
And these are always kind of confusing.
Is it the Series Name or the Category Name?
I think it's the Category Name here, but they
both sound pretty similar to me.
I'm going to turn on the Category Name and
it will give me
a label and a value and that's pretty much
what I wanted.
And you've got some other options here that
you can turn on and off, but these are the
big ones.
You want the value.
Sometimes you want the percentage instead
of the value, but
in this case they are the same, so the percentage
would be kind of redundant.
And if you want to move these labels, just
get your
four-headed arrow, and--come on--let's try
it again.
And it's not moving for me.
There.
There we go.
It's a little touchy on this stuff sometimes.
Let's try to move it.
And we'll take this one and we'll
try to move it and there we go.
So let's move that down a little bit lower.
OK.
So you can pretty much customize it anyway
you want to,
just like you could in Excel.
