Pie charts and subcategories

I want to create a pie chart using the attached Excel data. I have a main category (Types of Organisms), then within these categories I have the subcategories (Organisms). I want to use something like the bar of pie chart where the main pie displays the Types of Organisms and in the bar I want to display the Organisms. How do I do this? I've tried but can't see how to select the data so it appears as I've described. I definitely want to use a pie chart but don't know if the bar of pie chart is the appropriate one to use? Can someone help?