Removing Zero Percentages on a Pie chart

[Bob]

How do I remove Zero Percentages on a Pie chart. When
using percentages, even if the cell is blank it still show
the Zero Label on the chart.

Bob

 

[Debra Dalgleish]

One way is to filter the data:

1. Add headings to the data on the worksheet, e.g. Brand, Sales
2. Select a cell in the table
3. Choose Data>Filter>AutoFilter
4. From the dropdown list in the Sales column heading, select Custom
5. From the dropdown list, select 'Does not equal'
6. In the box, type a zero
7. Click OK

The chart will display the visible rows from the table.