delete 0 values in pie chart

[#1]

Hi, how do I delete zero values in pie chart as shown below? Thanks.

[Gysbert_Wassenaar]

On the Presentation tab is an option Suppress Zero-Values. If that is enabled then no 0 values will be shown. If you still see 0 values then those are not precisely 0. Perhaps you need to use a floor() function to round them down to 0.

[#3]

But it's 0.00% so doesn't it mean it's non-existent? So why does it still show in the chart?

[Gysbert_Wassenaar]

No, for example the value 0.000002 is not equal to zero. Not even if you format it so it displays in the format 0.00%. Try it in a textbox: =num(0.000002,'0.00%')