View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Chart Math incorrect

Don't you want to compute 6210/(6210+67221)? That's what equals 0.0846.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"
m wrote in message
...
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