Fusion Pie Chart

Working on our phyloinformatics project... My friend Dominic and I, we managed to merge all the New mammal species we pasted in excel and finally upload them in Google Documents, even though we had some difficulties, we did it..and know we need to process the data.. It seems as it's not as easy as we thought..

Trying to make a pie chart of the locality found in each specie, this is the pie chart that we got...therefore, we needed to find a way to modify it in order to recognize each "I" and "C" and group them and number them into one category each... Google is our friend...

I found that in order to make a pie chart, I should aggregate the data first. This counts the category in each locality and produces the following pie chart, by selecting Visualize -> Pie chart:

Where we can see that most new mammal species were found in a continental area (70.4%). We would suspect that, most species in an insular area would be known much earlier in time, however we have a 29% of them that were found in the last decade. Finally, only two new mammal species were found in the marine environment (0.6%). Source - analysis of data table in the following paper: DeeAnn M. Reeder, Kristofer M. Helgen and Don E. Wilson "Global Trends and Biases in New Mammal Species Discoveries" - Texas, USA, 2007. ...After completing the pie charts...I figured out how easy it was to make a time line.. and bar graphs... So I started "playing" with visualizations: