chart zero

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top