Force Pie Chart to be 100% in Numbers
I've created a few pie and donut charts in Apple Numbers recently and noticed they do not add up to 100% unless decimal places are used. If forgoing the decimal places, I usually get a chart with 101% as the total. This does not appear to be an issue with Microsoft Excel. Since I'm using the charts in an infographic, we want to avoid the decimal places if possible.
Any recommendations to force the pie chart to be 100% when calculated?
Sample data:
Extremely satisfied, 366
Somewhat satisfied, 405
Neutral, 127
Somewhat dissatisfied, 26
Extremely dissatisfied, 5
Sample charts:
As you can see, only the chart on the right adds up to 100%.