pie of pie

[TerryTutor]

Can Excel create a pie of pie chart that uses this data

Poodles - Qty 2 - 1 black, 1 white
Labradors - Qty 3 - 1 beige, 2 chocolate
Shepherds - Qty 1 - am. standard

Show all the dogs... and then break out the Labradors into a quantity of 3
with a pie of pie showing the different colors? If so? How do I set up the
data? (Hope this makes sense!)

 

[Barb Reinhardt]

When you are creating your chart, Pie of Pie is an option on the PIE Charts
selection in the Chart Wizard.

Once you get a Pie of Pie, you format the data series to choose how many of
the last points you want in our second PIE. I'd recommend sorting from high
to low in your data series.

HTH,
Barb Reinhardt

 

[Jon Peltier]

Your data will have to be prepared:

Poodles 2
Beige 1
Chocolate 2
Shepherds 1

Otherwise you'll have duplicate data.

When you make the Pie of Pie chart, apply the Data Labels showing Category
Names (step 3 of the Chart Wizard). Then with the created chart, drag the
wedges back and forth between the main and secondary pies to get them where
you want. The label in the main chart that splits into the secondary chart
is "Other", but you can select just this label (two single clicks) and
change it to "Labs".

- Jon