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

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

Depends on what kind of chart chart though?

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Rob" <[email protected]> wrote in message
news:[email protected]...
> 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

Hi Ken,

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

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

Cheers
Andy

Ken Wright wrote:
> Try =IF(H14=0,ISNA(),1780/H14)
>
> Depends on what kind of chart chart though?
>

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

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

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Andy Pope" <[email protected]> wrote in message
news:[email protected]...
> Hi Ken,
>
> I think you meant NA() instead of ISNA().
>
> =IF(H14=0,NA(),1780/H14)
>
> Cheers
> Andy
>
> Ken Wright wrote:
> > Try =IF(H14=0,ISNA(),1780/H14)
> >
> > Depends on what kind of chart chart though?
> >
>
> --
>
> Andy Pope, Microsoft MVP - Excel
> http://www.andypope.info

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

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------
<snip>

Hi Ken,

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

Cheers
Andy

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

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Cheers - Knew I wasn't going loopy there.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Andy Pope" <[email protected]> wrote in message
news:%23iWHo%[email protected]...
> Hi Ken,
>
> Doesn't work for area chart, that still drops to zero.
>
> Cheers
> Andy
>
> Ken Wright wrote:
> > Andy, sure I'm not going nuts - aren't there a copule of charttypes that
> > doesn't work on??
> >
>
> --
>
> Andy Pope, Microsoft MVP - Excel
> http://www.andypope.info