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 -

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
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

Jon inken wrote:

> 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