Charting only non-zero series

[travis]

I often do pie charts from which I need to delete a number of lables
because that particular value is zero, and I don't want the zero series
included in the pie.

What would be an easy way to get Excel to chart only the values which
are not zeros?

Travis

 

[Pete]

The way I do it is to have the labels in a column next to the values
and to have a filter covering the values. Apply a Custom filter for
Does Not Equal 0 (zero) - this hides the zero values and lables and the
pie charts automatically adjust.

Pete

 

[travismorien]

Thanks Pete!