What does your IF statement produce? If it gives an empty string "", then
it will be treated as zero. Change the "" to NA(). If you want to hide the
NA() values in the worksheet, you can do that by conditional formatting.
--
David Biddulph

"jhall@ifox" wrote in message
...
I don't want to display zeros in my line chart. The cells are not empty -
they contain a formula. I have used a simple if statement to hide a zero
value - however the chart is still showing the datapoint as zero.