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