NUMBERS loads random values into PIE CHART instead of selected cell values.

Question

NUMBERS loads random values into PIE CHART instead of selected cell values.

The chart looks good, but the values are NOT what are in the cells selected. Instead, Numbers is not just rounding up or down, but adding whole numbers up or down. For example, 30.0% is in the selected cell for a wedge. Numbers displays 32%.

How do I fix this since Numbers won't allow me to manually override what it loads?

Thank you.

Posted on May 15, 2024 8:14 AM

Reply

Answer 1

Badunit

Level 7

26,338 points

May 15, 2024 12:03 PM in response to My Own Help Desk

That's not how pie charts work. If your chart range is B2:B5, the first slice will be B2/SUM(B2:B5) as a percentage. The others will be similarly calculated. If the 30% in your table is not 30% of the total, which it appears to not be, it very well might be different on the pie chart.

This probably also answers your other question about pie chart data.

Reply