pie of pie

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

TerryTutor - 20 May 2007 02:24 GMT

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

Reply to this Message

Barb Reinhardt - 20 May 2007 12:30 GMT

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

> Can Excel create a pie of pie chart that uses this data
>
[quoted text clipped - 5 lines]
> with a pie of pie showing the different colors? If so? How do I set up the
> data? (Hope this makes sense!)

Reply to this Message

Jon Peltier - 20 May 2007 16:06 GMT

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
_______

> When you are creating your chart, Pie of Pie is an option on the PIE
> Charts
[quoted text clipped - 20 lines]
>> the
>> data? (Hope this makes sense!)

Reply to this Message