Here is my formula:
=IF(ISBLANK('Detail Qry'!E25),NA(),'Detail Qry'!E25)

It returns a #N/A like it is supposed to be it is still being charted on my
chart. I have tried ISERROR and ISERR but they don't work either.
I am actually using this formula to pull in a row of dates and then column A
is a work center. So really what i have is a crosstab.

Column A Column B Column C
5/29/07 5/30/07
L1 390 cs 502 cs
B4 425 cs 618 cs

When i run the query from the referenced sheet i will get the above crosstab
of data. But it will not always be the same dates and not always the same
work center in Column A. And there will not always be the same number of
rows or columns that come back. I have used Dynamic charts in the past but
not for something like this (not sure if it is possible). I only want to
chart what comes back in the query. Any help would be appreciated.