Hi, how do I delete zero values in pie chart as shown below? Thanks.
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.
But it's 0.00% so doesn't it mean it's non-existent? So why does it still show in the chart?
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%')
Retrieving data ...