How do I hide 0's from my pie-chart (see attached).

[stephenp12]

How do I hide 0's from my pie-chart (see attached).

Thanks in advance

S

[scottiex]

You can make the 0's evaluate to #NA e.g.

Please Login or Register  to view this content.

[MrShorty]

I would recommend reading this to see if it helps: https://peltiertech.com/mind-the-gap...g-empty-cells/

What are the 0 values doing that you need different? My expectation is that a pie chart would show no wedge where there is a 0 value, so there would be no need to avoid 0 values in a pie chart.

[stephenp12]

thank you very much