Click on Cell B11, type the Equals symbol =
Then click on the cell with the Total (in this case B10)
This will tell the formula to pull the total from the Total Formula
and use that figure in the calculation of the Average.

Then type the slash symbol /
and the number of the different colors (in this case 6)
Hit Enter

Note: What is really remarkable about this and differentiates this from
a plain word processing document is the fact that if you data changes the
formula will change too.

Office Version 2003
Making a Pie Chart

Office Version 2007
Making a Pie Chart

Go Back
Excel 2003 Start

Go Back
Excel 2007 Start