If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Simple pie chart question
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 |
#2
|
|||
|
|||
Simple pie chart question
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. -----Original Message----- 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 . |
#3
|
|||
|
|||
Simple pie chart question
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 ------- Jon Peltier, Microsoft Excel MVP http://www.geocities.com/jonpeltier/Excel/index.html _______ Jim Meyer wrote: 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 |
Thread Tools | |
Display Modes | |
|
|