I am trying to create a pie chart using basic, but changing data (sometimes
the value can be zero)
When it is zero, I do not want it to show

Blue 0
Red 2
Green 6
Yellow 0
Pink 4

I am trying to get it to show a pie chart with 'only' three entries (Red,
Green, Pink) and ignore the others.
However, next time I run it then green may be 0, and I would not want that
to show

If that makes any sense at all to anyone

Tony