Hi,

One way is to create another copy of your data, with a formula such as

=IF(B10,B1,"")

and then use Rob Bovey's free chart labelling add-in to add the data labels.

If the plotted value is zero, the correponding data label will be blank.

Dave

url:http://www.ureader.com/msg/10297257.aspx