Thank you both for your help. I'll try your idea Jim and see if it would be
accepted. I appreciate it.

tgcali

"Jim Thomlinson" wrote:

What you are asking is very ugly to do. Here is why. What you are showing on
the pie chart is the percentage instead of the value. What percentage is
doing is it is allocating the the extra 1% to the 43 because 43 is the
largest value in the set. The actual percentages are 23.333, 43.333 and
33.333. None of those numbers rounds up. The extra 1% is based on the size of
the slice. Now if your data was 11, 11 and 6 your pie chart will show 39%,
40% and 21%. Since 11 and 11 are equal the 40 is an arbitrary allocation of
the extra 1%.

My recommendation would be to change the pie chart to show the value insted
of the percent. Then your chart will show the 43.3, 33.3 and 23.3 percent.
--
HTH...

Jim Thomlinson


"tgcali" wrote:

Hello,

I need to round up the answer for this simple formula in whole numbers

=D8/D3

The problem is that that the breakdown is equaling 99% and I have to make it
equal 100%. On my pie chart that accompanies the stat sheet it shows the
breakdown of my three categories like this:

30 total
7 = 23%
13 = 44%
10 = 33%

On the stat sheet it shows 23%, 43% and 33% respectively. I've been told to
make them match. So I need the percent for D8/D3 to equal 44%.

Any help would be greatly appreciated.

tgcali