year institute 1 institute 2
2005-2006 211 198
2004-2005 219 175
2003-2004 201 169
2002-2003 119 112
2001-2002 105 98
how can I calculate % for following chart from which I want to draw pie chart
---------------------------
Add the "institute 1" column to get 855
Divide each year total by 855 to get the % for the year:
Example
211/855 is very close to 25%
etc.
Cheers,
Stan H.