Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Normalize the second pie in a pie of pie chart
21 views
Skip to first unread message
Judy
Jan 20, 2005, 4:43:09 PM1/20/05
to
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.
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
Jan 21, 2005, 6:48:01 AM1/21/05
to
Hi,
Have a look at Jon Peltier's article on Pie of Pie. mmmh pie! :)
http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=471
Cheers
Andy
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
0 new messages