greenxgene

  No matter in version of MS Office you are working with, this simple trick will always work. Lets get to the topic straight. Here is a table I have for which I need to draw a graph. We have zero values for two cities - Narnia and Atlantis (Assuming that everyone is wiped out in zombie apocalypse). City Population in Millions Chennai 243 Bangalore 527 Narnia 0 Atlantis 0 Mumbai 457 Delhi 23 Kolkata 10 Here is the typical graph we generated in excel for the above table. One thing that looks un-presentable in this chart is the zero values at the bottom of the pie chart. Here are the steps to remove the zero values. Right-click on any of the data labels (the numbers representing the population here) and select Format Data Labels . A Pop-Up for Format Data Labels will open. In that navigate to Number tab. In Number tab under Category , select Custom and enter the Format Code as below 0;;; Click Add and Close the window. Now your graph will ...