Chart question

J

Johnfli

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
 
A

Andre Croteau

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é
 
J

Jon Peltier

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
 
Top