Pie charts and subcategories

**kdestef1** · 06-19-2009, 12:04 PM

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?

**Andy Pope** · 06-20-2009, 09:56 AM

A bar of pie is not possible as it will only display information for 1 of the main categories.

You might be able to should a pie within pie using these tricks,
http://www.andypope.info/charts/pies.htm

But will 37 slices it will be almost impossible to get real meaningful information from the chart.

This maybe useful
http://pubs.logicalexpressions.com/P...cle.asp?ID=471

**Andy Pope** · 06-20-2009, 10:25 AM

This chart displays the sections in ranked order.
The horizontal lines and group labels are created using xy-scatter series.

The secondary axis can be formatted so the values are not displayed.