Chart data source

[Rob]

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

 

[Ken Wright]

Try =IF(H14=0,ISNA(),1780/H14)

Depends on what kind of chart chart though?

 

[Andy Pope]

Hi Ken,

I think you meant NA() instead of ISNA().

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

Cheers
Andy

 

[Ken Wright]

Dohhhhhhhhhhh - Cheers Andy. So used to testing for it as opposed to
creating one - grrrrrrrrr -

 

[Ken Wright]

Andy, sure I'm not going nuts - aren't there a copule of charttypes that
doesn't work on??

 

[Andy Pope]

Hi Ken,

Doesn't work for area chart, that still drops to zero.

Cheers
Andy

 

[Ken Wright]

Cheers - Knew I wasn't going loopy there.