This link shows how you might set this up:

http://www.cellmatrix.net/index.php/...e_zero_values/

--
John Mansfield
cellmatrix.net


"Cris" wrote:

I have a range based on which a pie chart is shown. I do not want the cells
containing zero values in the range to be considered or shown in the pie
chart automatically. How do I do this