View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
[email protected] diamondgator@hotmail.com is offline
external usenet poster
 
Posts: 6
Default Chart Math incorrect

Given A2 = 67221; K14 = 6210
Formula in pie chart comparing two values and display as whole pie
=(Overview!$A$2,Overview!$K$14)

In effect it should show the percentage of the whole

Chart math says 6210/67221 = .08457
when in actuality it equals .09238

Cell Formats for all cells verified to be set to numbers

Is there something that I am missing here??

Thanks,
Rich