Hi,
Within a donut chart zero sections are not visible. But if you have data
labels or a legend then their information is still displayed.
Here are some pages on suppressing information. They are both based on
pie charts by the principles for donut are the same.
http://pubs.logicalexpressions.com/P...cle.asp?ID=390
http://www.andypope.info/charts/piezeros.htm
Cheers
Andy
Johnfli wrote:
I have a series of data number that goes into a nice doughnut type chart.
The data is dynamic. Sometimes some of the data items will be zero.
How can I set it so that the items that are zero do not display on the
chart?
Thanks
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info