Removing Zero Percentages on a Pie chart

  • Thread starter Thread starter Bob
  • Start date Start date
B

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
 
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.
 
Back
Top