You might use a helper column and have a formula of type =if(a1=0,NA(),a1)

Any #N/A value do not appear on charts.

rgds

André


"Johnfli" wrote in message
...
I have a series of data number that goes into a nice doughnut type chart.
The data is dynamic. Sometimes some of the data items will be zero.

How can I set it so that the items that are zero do not display on the
chart?

Thanks