Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Chart formatting | Charts and Charting in Excel | |||
Pivot Chart: cannot apply the default chart type... | Charts and Charting in Excel | |||
Problem with xlusrgal.xls file | Charts and Charting in Excel | |||
pivot table multi line chart | Charts and Charting in Excel | |||
Why do my text boxes disappear from my chart when I click out? | Charts and Charting in Excel |