Yes there is, however this will be a simple IF fuction

Say you chart info cells is B5:B10

Use the following in cell C5:C10 and use cells C5:C10 as your new data
range

=IF(B50,B5," ") and if any number = 0, it wont be calculated into you
pie chart

Cheers


Thiem


--
Thiem
------------------------------------------------------------------------
Thiem's Profile: http://www.excelforum.com/member.php...o&userid=27474
View this thread: http://www.excelforum.com/showthread...hreadid=480868