Piechart Zero Segments
 

I would like to keep the series but display non of the zero segments.

Piechart Zero Segments
 

What I do (assuming the values are in a column) is to apply a custom
filter to the values, choosing Does Not Equal and entering zero - the
zero values are hidden on the sheet, and do not appear on the pie
chart.

If the values change, eg. next month, just re-apply the filter (it is
not dynamic).

Hope this helps.

Pete

On Apr 10, 5:19*pm, Sarah wrote:
I would like to keep the series but display non of the zero segments.