Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
3d Pie in Excel 2007
I have a sample series of 4,1,1 total of 6 in which I made a 3d pie chart.
The largest section (4)is showing 67%, the 2nd section (1) is showing 17% while the 3rd section (1) is showing 16%. I know there is rounding here, but in actual %, showing 1 decimal place the results are 66.7, 16.7 and 16.7. The percentages shown on the chart are from choosing percentage rather than value. It seems as if Excel is rounding up on 2 of the slices and rounding down on the 3rd slice so as not to go over 100%. Analyzing the chart, one has to ask: why are two equal shares not showing the same percentage.? Is this a bug or am I not configured correctly? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
3d Pie in Excel 2007
Hi,
I am able to duplicate your problem and it certainly seems like a bug. If you change the format of the data labels to Number or just about anything other than General there seems to be no problem. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Meebers" wrote: I have a sample series of 4,1,1 total of 6 in which I made a 3d pie chart. The largest section (4)is showing 67%, the 2nd section (1) is showing 17% while the 3rd section (1) is showing 16%. I know there is rounding here, but in actual %, showing 1 decimal place the results are 66.7, 16.7 and 16.7. The percentages shown on the chart are from choosing percentage rather than value. It seems as if Excel is rounding up on 2 of the slices and rounding down on the 3rd slice so as not to go over 100%. Analyzing the chart, one has to ask: why are two equal shares not showing the same percentage.? Is this a bug or am I not configured correctly? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
3d Pie in Excel 2007
I agree...another oddity? is that you can edit the 16% and change it to 17%
right on the pie chart itself. This I have done on my presentation that includes 4 other pie charts, some need help, others did not. I fixed them all to keep the "suits" happy. "Shane Devenshire" wrote in message ... Hi, I am able to duplicate your problem and it certainly seems like a bug. If you change the format of the data labels to Number or just about anything other than General there seems to be no problem. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Meebers" wrote: I have a sample series of 4,1,1 total of 6 in which I made a 3d pie chart. The largest section (4)is showing 67%, the 2nd section (1) is showing 17% while the 3rd section (1) is showing 16%. I know there is rounding here, but in actual %, showing 1 decimal place the results are 66.7, 16.7 and 16.7. The percentages shown on the chart are from choosing percentage rather than value. It seems as if Excel is rounding up on 2 of the slices and rounding down on the 3rd slice so as not to go over 100%. Analyzing the chart, one has to ask: why are two equal shares not showing the same percentage.? Is this a bug or am I not configured correctly? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Analysis Toolpack Issues in Excel 2007 (Office 2007 Enterprise) | Excel Discussion (Misc queries) | |||
Excel 2007 files not showing on screen when opened in Excel 2007 | Setting up and Configuration of Excel | |||
Excel 2007 Query Wizard problem with Access 2007 extensions | Excel Discussion (Misc queries) | |||
Labels: Unable to import all records Excel 2007 to Word 2007 Mailm | Excel Discussion (Misc queries) | |||
Paste EXCEL 2007 sheet into WORD 2007 - objects move around | Excel Discussion (Misc queries) |