In a pie chart no slice is shown for a zero value, so unlike other chart
types you don't really need to cater for it. Or, do you mean not display
Legend Entries with zero values. That could be done with a macro, though it
would need to be rerun each time values change.

Regards,
Peter T


I currently have some data as shown below:

Item 1 0
Item 2 3
Item 3 6
Item 4 5
Item 5 0
Item 6 9

How can I exclude the zero items automatically, the data shown below is
going to change regulary and i do not want to have to keep change the
source
data manually.

D