Chart Math incorrect

[diamondgator]

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

 

[Jon Peltier]

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
_______


"(e-mail address removed)"

 

[diamondgator]

Not Really...

67221 is equal to the total number of files to be processed whereas 6210 is
the number of files processed. Should show as a percentage of the whole.

Tried to pre-compute values and use those instead but nothing I tried worked

~ Rich

 

[Jon Peltier]

You mentioned a pie chart. None of the data points going into the pie should
be the total; all the parts going into the pie chart should add to the
total. You either want 6210 and 67221 as the segments and 6210/(6210+67221)
as the proportion, or you want 6210 and (67221-6210) as segments and
6210/67221 as the proportion.

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


"(e-mail address removed)"