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? |
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) |