I just downloaded and test the workbook and it functions for me.
Zero items are removed from pie, data labels and legend.

To get rid of zero data labels use a custom number format (whole values
only)
0;;;

Cheers
Andy

ksp wrote:
Hi Andy

Thanks for that - It seems to work however I have to manually delete
any data labels for that line that has missing data

Do you know of a way to get the data labels to also update with the
changing data? The link that you gave me says that it updates the
legand but not for me.

Thanks

Karen



--

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