Charting only non-zero series

  • Thread starter Thread starter travis
  • Start date Start date
T

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
 
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
 
Back
Top