software

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
You might use a helper column and have a formula of type =if(a1=0,NA(),a1)

Any #N/A value do not appear on charts.

rgds

Andréquot;Johnfliquot; gt; wrote in message
...
gt;I have a series of data number that goes into a nice doughnut type chart.
gt; The data is dynamic. Sometimes some of the data items will be zero.
gt;
gt; How can I set it so that the items that are zero do not display on the
gt; chart?
gt;
gt; Thanks
gt;
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.

pubs.logicalexpressions.com/P...cle.asp?ID=390
www.andypope.info/charts/piezeros.htm

Cheers
Andy

Johnfli wrote:
gt; I have a series of data number that goes into a nice doughnut type chart.
gt; The data is dynamic. Sometimes some of the data items will be zero.
gt;
gt; How can I set it so that the items that are zero do not display on the
gt; chart?
gt;
gt; Thanks
gt;
gt;

--

Andy Pope, Microsoft MVP - Excel
www.andypope.info

True for line and XY charts. Try it with a column, pie, or donut chart. The
value is interpreted as zero, but if you have data labels, the #N/A shows
up. You're better off with zeros and a number format like quot;0;;;quot; which shows
positive values, but not zero or negatives.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
PeltierTech.com
_______quot;Andre Croteauquot; gt; wrote in message
...
gt; You might use a helper column and have a formula of type
gt; =if(a1=0,NA(),a1)
gt;
gt; Any #N/A value do not appear on charts.
gt;
gt; rgds
gt;
gt; André
gt;
gt;
gt; quot;Johnfliquot; gt; wrote in message
gt; ...
gt;gt;I have a series of data number that goes into a nice doughnut type chart.
gt;gt; The data is dynamic. Sometimes some of the data items will be zero.
gt;gt;
gt;gt; How can I set it so that the items that are zero do not display on the
gt;gt; chart?
gt;gt;
gt;gt; Thanks
gt;gt;
gt;
gt;