chart zero

[First & Last]

Hello, first Post - so here goes....

I am ploting a simple chart in Excel - when the value of a cell, say F5, is
zero (calculated as =F4/F3) or F4 and F3 are zero and F5 returns #DIV/0! - I
don't want to plot that cell at all.

At the moment it is plotted as zero in both cases.

I'm using Excel 2000.

Many Thanks
Andy

 

[First & Last]

Have just found the other threads dealing with this issue - #N/A and a white
font will do it for me.

Thanks anyway guys
Andy