Thread: Chart question
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Andy Pope
 
Posts: n/a
Default Chart question

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