Not sure what detail you need. Is it possible to make pie charts on each individual spreadsheet?

Sure it's possible, but this is not my projects so I don't fully understand how the data should be displayed.

You have to help us more by showing the input data. Not the data as you have it, but what exactly in the data should be in the chart. Surely it's not all the data.

Look at these sites for some inspiration...

http://www.andypope.info/charts.htm
http://peltiertech.com/jons-excel-and-chart-pages/