Bar-of-pie Charts

[Jon inken]

I cannot seem to get this to work but I want to create
either a bar of pie or a pie of pie.

I have 3 data poits adding to 100% (easy Pie chart) Say
Fruit(50%), Veggies(25%) and Grains (25%). I want to
explode the fruit by showing it's composition. so of the
50% 33% is apples, 40% is plums, and the remainder
grapes. That subset represents 100% of the fruit which
represents 50% of the total. Can I do this with a bar or
pie of pie graph and how do I do it?


Jon

 

[Jon Peltier]

Jon -

Combine your two sets of data:

grains 25.0%
veggies 25.0%
fruits 50.0%

apples 33.0%
plums 40.0%
grapes 27.0%

into one:

grains 25.0%
veggies 25.0%
apples 16.5%
plums 20.0%
grapes 13.5%

so that apples, grapes, and plums add to the 50% which is the fruit
proportion. Make a pie of pie from this data. Double click on one of the
pies, and on the Options tab, change it to "Second plot contains the
last 3 values".

- Jon