Hi.

So, i've gone through several iterations of trying to solve this problem. I have a chart pulling data from a range of cells with formulas in them. Some of the cells have formulas which currently return #N/A, but which may in the future return a numerical value. I need a chart which:

1) Does not chart cells which return #N/A
2) Does chart new cells within a defined range once they stop returning #N/A and return a value instead.


I have tried using formulas using na() when the formula is false. This doesn't seem to work.

In addition, I have tried to set a dynamic range, using the countif(range,">0"). Also does not seem to work.

Help! I've attached the workbook.
Ignore NA in Chart.xlsx