Here's a fun project you can do in Numbers.
You can create a checklist and then a pie
chart and then have your pie chart automatically
track your progress as you check items off
in the checklist.
The first thing I want to do is I want to
get rid of the default table there.
I'm want to create a new one that's a checklist
type.
You can see it gives you that.
I'm going to get rid of everything except
the one column here.
So let's just give it a title and I'm going
to put some placeholder items here like, for
instance, let's just do one, two, three, etc.
So let's say these are things you need to
do and you can check these off very easily
by using the checkboxes there.
Let's just give this a heading there.
Now we want to add the chart which is going
to be a simple pie chart.
That's going to be here on the right.
Now in order to get this pie chart to work
like we want it should show basically zero
percent when nothing is checked and 100% when
everything is checked.
So we need to have those numbers represented
somewhere.
I'm going to create another table.
Just a totally blank table here and I'm going
to shrink it down so we just have these two
columns here with just one row each.
In this column we're going to put the item
that will represent how many of these are
checked off.
So we want to use a formula for that.
I'm going to hit the equal sign and in order
to do that I'm going to use the count if formula.
Count if and I'm going to do it on this column
here and what I'm looking for is for them
to be true.
So now I see I get a zero and if I check any
of these off it will count the number that
are true.
So now I want to further change this because
I don't want it to be actually the number,
I want it to be the percentage.
So what I want to do is I want to divide this
number by the total number of check boxes
there are.
So at the end of the formula here I'm going
to hit the slash key, it will give me a divided
by, and what I'm going to do to count the
number of items here is I'm going to use the
Count A which will count the number of non
blank cells in A. So now when I check them
off you can see it's going to add up to 100.
The reason I wanted to do non blank cells
is because this first one up here, you could
see is blank because there are actually ten
rows but the first one is the header row.
So by counting only the non blank ones I'm
getting a total of nine rather than ten.
If I used another function like rows I would
actually get ten which wouldn't give me an
accurate count.
So now I have a good percentage here.
If I wanted to I could change this here to
go to cell and change it to percentage so
I can see that maybe even turn off the number
of decimals.
I can see it now clearly what percent of these
are checked.
Now I want to figure out what percentage are
not checked.
That's pretty easy to do because all I need
to do here is basically say one, I'm going
to do a formula equals one minus this cell
and this gives me the opposite.
So I get 22%, 78%.
33%, 67%.
That's great.
So that's what I need now for this pie chart
to show me the percent complete and percent
not complete.
So I'm going to select the pie chart, hit
Edit cell references, select these two here,
and I'm going to deselect this one by clicking
on it and hitting the delete key.
So now I just have these two here.
22% and 78%.
Now I can further customize this pie chart
if I want.
So I can actually go into like the widget
here.
I can double click and you can see I selected
just the green widget.
I turn off values so you don't see that value
there.
I can go ahead and change different things
about like say the style.
So if I wanted to change it to No Fill, for
instance, I can remove it.
Or I can change it to a basic color fill and
maybe just make it gray.
Now I'm all set.
When I check these boxes you can see the pie
chart grows.
I can further customize this.
I can get rid of the legend at the top.
I can arrange this different ways that I want.
I can change it's style.
All sorts of different things.
I can also get rid of this if I want.
An easy way to do it is just to move it behind
here.
So I'm going to put it right over on top of
this and I will go to Arrange and I'm going
to bring to front so the pie chart is actually
going to cover that one.
So now as I go through my checklist I can
see what percentage I've done.
It's great for teams.
If you have a computer that's tracking everybody's
progress to get a task done you can, as you
check off items, see how close you're getting
to 100%.
