Plotting results from with IF, IFERROR, and INDIRECT statements

[ray crad]

Hi,
I am working on an excel spreadsheet where I wish to plot values obtained through a combination of IF, IFERROR, and INDIRECT statements.
Everything was plotting correctly until I added the IFERROR function, and now the data points will not plot. Instead, the series just goes blank.
I used the IFNUMBER function with the full formula to test that it is registering as a number, and it said "TRUE", so I am at a loss here.

Is there an option I need to toggle, or does anyone know what might be going on?
P.S. - I am using Excel 2016 on windows. I would also prefer to avoid uploading a mini-sheet as this template is proprietary work owned by my employer.

Thanks in advance!

 

[StephenCrump]

Welcome to the Forum!

Are you able to replicate the problem with a simpler non-confidential example you could post using XL2BB: XL2BB - Excel Range to BBCode

Or at least post the problematic formula you're using for the series?

 

[ray crad]

Thank you!
The x-axis columns are populated with the following formula: =IF(ISERROR((I13+H13)/2),"",(I13+H13)/2)
The y-axis columns are populated with: =IF(ISERROR($B$9-M13),"",$B$9-M13)

What is strange is when I create a new plot, it works momentarily, and then the data points disappear...