Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Bug in Rounding percentages of Bar of Pie chart
(Excel 2003)
Suppose sales values for January to June are 25,50,90,45,100, and 75, respectively. Bar of pie chart with a second plot containing the sales values whose percentage values are less than 15%. The problem is that, Excel draws the pie chart with a total percentage of 102 %. The percentage of the total sales included in the bar is 33%. Now if you increase its decimal, it is seen that its actual value is 31.2 %. How Excel 2003 rounds 31.2 % as 33 %. Now changing sales value for April from 45 to 47, it is seen that bar percentage becomes 34 %, and total percentage for the pie becomes 103 %... When increasing the decimal for 34 % it has changed to 31.5 percent. Chart percentages fail for some particular data like this.. Any comments about this? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Activating a Chart object | Charts and Charting in Excel | |||
Urgent Chart Assistance | Charts and Charting in Excel | |||
Urgent Chart Questions | Excel Discussion (Misc queries) | |||
Urgent Chart Assistance Requested | Excel Discussion (Misc queries) | |||
Scrollbar on Chart Jumps to Left when Chart is Clicked | Charts and Charting in Excel |