Question 124319
how can I calculate % for following chart from which I want to draw pie chart


  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.