KB0028: The percentage values I entered in the datasheet accumulate to 100%. However, when I choose a different number of decimal places in the chart, the rounded values are slightly off

Cause

It is a known mathematical problem that the total of rounded values not necessarily equals the rounded total of the precise values.

Solution

Our tool think-cell round, which comes for free with your installation of think-cell, ensures that all numbers are rounded consistently and precisely add up to the rounded total. Using think-cell round to prepare a presentation is particularly convenient if you use think-cell's Excel data link feature to create PowerPoint charts from the rounded data.

Refer to

Online product documentation