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é


"Johnfli" wrote in message
...
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

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

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 "0;;;" which shows
positive values, but not zero or negatives.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Andre Croteau" wrote in message
...
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é


"Johnfli" wrote in message
...
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