As another option, perhaps this example might help. It shows shows how to
exclude zeros but should also work with blanks.

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

--
John Mansfield
http://cellmatrix.net





"Emile" wrote:

I have a column with 55 rows. If there is a value in any cell I want to
take those values (never more than 10) and create a pie chart. The
description for each piece of the pie would come from a cell three columns
to the left in the row that has a value.

The chart has a legend.

Can I automatically create a chart with only the number of pies that
represent the cells that have a value and automatically generate the correct
legend?

The way I am doing it now if only 2 cells have values, I get a chart the two
values plus 8 with 0 values and still 10 entries in the legend.

Any suggestions

Thanks in advance for your help.