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