Hi,

Have a look at this example.
http://www.andypope.info/charts/piezeros.htm

Cheers
Andy

Simon wrote:
I have a pie graph created from 36 rows by 1 numeric 'count' column. I have
created a pie chart which shows the count distribution based on the 36 rows.
Where a row has zero count, there is no slice. I would like to turn off the
legend entry automatically where a row has a zero count, thereby reducing the
overall size of the legend table.

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info