Pie of Pie

[Jeff]

Can anyone walk me through how to build a "pie of pie" chart? That is, I
need a secondary pie chart to "explode" a slice of the main pie chart.
Excel's help was not too helpful on this topic.

 

[Luke M]

While I might argue that you should never use a pie of pie chart (there are
so many other useful options that don't distort data!!!), this feat is
accomplished by using the Chart Wizard - Chart type, pie of pie. Then, when
you format a series, under the options tab, you can choose how many series
you want to include in the second pie.

 

[Billns]

Can anyone walk me through how to build a "pie of pie" chart? That is, I
need a secondary pie chart to "explode" a slice of the main pie chart.
Excel's help was not too helpful on this topic.

This article may help:
http://office.microsoft.com/en-us/excel/ha011179371033.aspx

If not Google for more...

Bill

 

[Jeff]

Thanks, Micky. Worked the first time!

Check this out:
http://office.microsoft.com/en-us/excel/HA011179371033.aspx
Micky

 

[Bruce Sinclair]

Can anyone walk me through how to build a "pie of pie" chart? That is, I
need a secondary pie chart to "explode" a slice of the main pie chart.
Excel's help was not too helpful on this topic.

Please don't do this. I suggest you read edward tufte's fine book on the
visual display of data for the resons why. He has a great example of why
this is abomination.

 

[Billns]

Can anyone walk me through how to build a "pie of pie" chart? That is, I
need a secondary pie chart to "explode" a slice of the main pie chart.
Excel's help was not too helpful on this topic.

I have to agree with Bruce and Luke. The results are not very pretty...

Bill