Pie charts and removing 0%

[Sharr76]

Hi, how can I remove any % showing zero and at the same time remove any categories that relate to 0%. But would reappear if the % was greater than zero

[teylyn]

Hello,

if a zero is plotted in a pie chart, that means that the cell contains a 0. In this case you can

- delete the 0 from the cell, so the cell is empty. Then it won't be plotted
- if the cell contains a formula that returns a 0, change the formula to return NA() instead. Then that cell will not be included in the chart.

2015-05-05_11-15-07.png

Remember that pie charts should not have more than a few data points. If you have more than 4 slices in the pie, a bar chart will be a better data visualisation.

[Andy Pope]

If you want the legend to also update
http://www.andypope.info/charts/piezeros.htm