AJP Excel Information

Automatic removal of zero values in pie chart

You can see from the above images the effect of setting data items C and F to zero.

The workbook contains an example of a pie chart that automatically removes zero values from the pie and the legend.

The chart uses named ranges in order to dynamically expand or contract.

The formulas used to remove zero data points are courtesy of Doug Tyrrell (www.dotxls.com)

Updated to include formula to handle data laid out in rows rather than columns.

Alternative links

Jon Peltier's Tech Trax article 'Pie charts in Microsoft Excel'