Thread: Normalize the second pie in a pie of pie chart

I have Excel 2003. I'd like to have the second pie in a pie of pie chart
represent 100% of the slice it details. Currently, the slices in the second
pie show their percentage of the 1st pie not their percentage of the slice
they come from. One of my clients insists that the second pie show percent of
the slice they detail not percent of the original pie. Other than creating
separate pie charts, is there a way for Excel to normalize the percentages in
the second pie.

Thanks,
Judy H

Hi,

Have a look at Jon Peltier's article on Pie of Pie. mmmh pie!
http://pubs.logicalexpressions.com/P...cle.asp?ID=471

Cheers
Andy

Judy wrote:
> I have Excel 2003. I'd like to have the second pie in a pie of pie chart
> represent 100% of the slice it details. Currently, the slices in the second
> pie show their percentage of the 1st pie not their percentage of the slice
> they come from. One of my clients insists that the second pie show percent of
> the slice they detail not percent of the original pie. Other than creating
> separate pie charts, is there a way for Excel to normalize the percentages in
> the second pie.
>
> Thanks,
> Judy H

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info