View Single Post
  #1   Report Post  
Rob
 
Posts: n/a
Default Chart data source

I need my chart to be blank between 2 points but the data
source it takes from contains the following formula

=IF(H14=0,"0",1780/H14)

even if I change it to

=IF(H14=0,"",1780/H14)

It still has the same effect unless the cell is cleared
using the delete button. This I dont want to have to do
because the person entering the information I have asked
not to delete formulas

Thanks

Rob