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

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

Chart Math incorrect
 

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" wrote:

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

Chart Math incorrect
 

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
_______


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

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