We just ran into a real problem where the Charting on Excel will recalculate
your numbers.

Excel wants to make it 100%

The problem is that our numbers are not 100%.

For example:

I have a table:
A B C
35% 25% 0%

What we got was a Pie Chart that showed:

A B C
61% 39% 0%

I have another one that is11,26,11,1,2 which equates to (in percentage)
21.57,50.98,21.57,1.96,3.92. Now this equates to 100%. but the table I am
using only has whole numbers: 22,51,22,2,4 which equates to 101% (which is
incorrect). This is a rounding anomaly in that all the numbers rounded up -
not much you can do about that. But the problem chooses which number to
change to make it 100% (in this case it changed the 51 to a 50).

Is there a way to tell the Pie Chart not to adjust the numbers even if they
don't equal 100%?

The problem here is that if you look at the table and the chart, they are
different and it looks incorrect because it doesn't match.

Thanks,

Tom