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
Bookmarks