Have a read of this article & see if it helps you.

http://pubs.logicalexpressions.com/P...cle.asp?ID=390
--
jb


"John V" wrote:

I create a pie chart from a set of values (formulas), some of which may
compute as zero from time to time. Because the data range contains formulas
(I guess), the cells aren't interpreted as zeros or empty cells. So, the pie
chart may contain one or two 0 percent slices. (Actually, there's a title and
a line drawn to one or more non-existent slices.) I would like to avoid such
a picture, drawing only non-zero slices.

Is there a way to do this?