to a non-zero value, the originally zeroed value will be invisible.
Demo: I can get around this issue by setting the y value to something small, but this obviously isn't correct. Incase the demo doesn't work, code is here: The problem is that set Data animates the existing slices to accomodate the new values.
For example, in the pie chart below, without the data labels it would be difficult to tell that coffee was 38% of total sales.
There does appear to be an issue with a blank Chart that is created, and then data from the Table is added-the Chart data doesn't track changes to the Table (it retains its initial range). select the Table data and then Insert is one answer here.
Once you set the range, anything inserted into that range is taken into account.
There are a number of ways to apply custom data labels to your chart: The least sophisticated way to get your desired text into each label is to manually type it in.
Click once on a label to select the series of labels.