View Single Post
  #1   Report Post  
Judy
 
Posts: n/a
Default 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