Ignoring Blank/Empty Cells that contain formulas

I have a column row of formula's that take data from another worksheet, when
there is an error in the original data it leaves the cell blank.

Formula =IF(ISERR('JAN 2005'!Y55),"",'JAN 2005'!Y55)

My problem is that there is a graph generated from this column and it treats
all the blank cells as zero, this messes up the graph and shows it dropping
to zero. (The errors alway happen at the end of the data)

Is there a way to get the graph to ignore the zero figures or rebuild the
formula to show the cell as truly blank?


Regards

Paul

Change the formula to

IF(ISERR('JAN 2005'!Y55),NA(),'JAN 2005'!Y55)

and try it again.

"pabown" <[email protected]> wrote in message
news:[email protected]...
> I have a column row of formula's that take data from another worksheet,
when
> there is an error in the original data it leaves the cell blank.
>
> Formula =IF(ISERR('JAN 2005'!Y55),"",'JAN 2005'!Y55)
>
> My problem is that there is a graph generated from this column and it
treats
> all the blank cells as zero, this messes up the graph and shows it
dropping
> to zero. (The errors alway happen at the end of the data)
>
> Is there a way to get the graph to ignore the zero figures or rebuild the
> formula to show the cell as truly blank?
>
>
> Regards
>
> Paul
>
>

Thanks for the quick reply Barb,

Your adjustment just gives me a result of #N/A in the cell and my graph
still takes the result to read zero


Regards

Paul



"Barb Reinhardt" wrote:

> Change the formula to
>
> IF(ISERR('JAN 2005'!Y55),NA(),'JAN 2005'!Y55)
>
> and try it again.
>
> "pabown" <[email protected]> wrote in message
> news:[email protected]...
> > I have a column row of formula's that take data from another worksheet,
> when
> > there is an error in the original data it leaves the cell blank.
> >
> > Formula =IF(ISERR('JAN 2005'!Y55),"",'JAN 2005'!Y55)
> >
> > My problem is that there is a graph generated from this column and it
> treats
> > all the blank cells as zero, this messes up the graph and shows it
> dropping
> > to zero. (The errors alway happen at the end of the data)
> >
> > Is there a way to get the graph to ignore the zero figures or rebuild the
> > formula to show the cell as truly blank?
> >
> >
> > Regards
> >
> > Paul
> >
> >
>
>
>

pabown wrote:
>Your adjustment just gives me a result of #N/A in the cell and my
graph
>still takes the result to read zero
....
>"Barb Reinhardt" wrote:
>>Change the formula to
>>
>>IF(ISERR('JAN 2005'!Y55),NA(),'JAN 2005'!Y55)
>>
>>and try it again.
....

What kind of chart are you generating? Barb's approach works for x-y
and line charts, but not for column or bar charts.

Tried it again and it worked perfectly, I must have made a mistake when
modifying the original formula, Thanks

"Harlan Grove" wrote:

> pabown wrote:
> >Your adjustment just gives me a result of #N/A in the cell and my
> graph
> >still takes the result to read zero
> ....
> >"Barb Reinhardt" wrote:
> >>Change the formula to
> >>
> >>IF(ISERR('JAN 2005'!Y55),NA(),'JAN 2005'!Y55)
> >>
> >>and try it again.
> ....
>
> What kind of chart are you generating? Barb's approach works for x-y
> and line charts, but not for column or bar charts.
>
>