Pie of Pie Second Pie Total 100%

[Tanya]

In Excel when I use the Pie of Pie chart type and display percentage
data labels, the 2nd pie percentages total the amount of the slice
it's consolidating. Is there any way to make the 2nd pie percentages
total 100%? Thanks,

 

[Shane Devenshire]

Hi,

Nothing I know of the do this automatically, however you might make a
separate column in your data area to calculate the percentages for the
sub-pie.
And then use the XLChartLabeler to add these as data labels to your chart.

You can get the free add-in at

http://www.appspro.com/Utilities/ChartLabeler.htm

 

[Andy Pope]

Hi,

You might be able to use the Pie by Pie example.
http://www.andypope.info/charts/pies.htm

Cheers
Andy