pie of pie
 

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!)

pie of pie
 

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

"TerryTutor" wrote:

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!)

pie of pie
 

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Barb Reinhardt" wrote in message
...
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

"TerryTutor" wrote:

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!)