Simple pie chart question

[Jim Meyer]

I'm a teacher trying to make a pie chart illustrating a
part of a whole as a percent.

I have two columns, one column (A1-A10)contains the total
possible points for assignments 1 -10 the other column (B1-
B10)contains the points earned for assgnments 1-10. the
cell below each column has a formula that displays the sum
of cells X1 - X10. So if a student has earned 75 points
out of a possibe 100 you will see 100 in cell A11 and 75
in cell B11. OK.

My question is how do I make a pie chart that will display
something that looks like it is 75% one color and 25%
another. I keep getting pie charts that look like they are
dislpaying two different values rather than one value(75%)
that is part of a whole.

Thanks. Really thanks alot.

Jim

 

[bkm]

Jim;

You could try this.
Say the possible points are in col. 'L', and the scored
points are in 'M'.

Near the scores say in 'N12', divide the total scored by
the total possible - the 'M' sum divided by the 'L' sum.
Then right next to that, say in N13, enter "=1-N12".
Format those two cells as percentage using the % tool on
the Formatting toolbar.

You can then click and drag from the student's percentage
(N12) to the remaining percentage (N13), press F11,
switch to pie chart, dress it up - done.

 

[Jon Peltier]

Jim -

In C1, put the formula =A1-B1, to get the amount that the student didn't
earn. Drag this down to fill C1:C10.

Make each chart with each row's values in B and C. To make the first
chart, for example, select B1:C1 and start the chart wizard. Use the
Show Percents option for Data Labels, if you like.

- Jon