Ignoring Blank Cells in a Chart

[avidcat]

The attached sample has a chart and it is marking blank cells as "0".

The blank cells have a formula in them so I think ignoring blank cells will not work.

How can I ignore these blank cells so they do not show up in the chart.

Thanks for any help.

Nick

[teylyn]

Hello,

in your formula, use NA() instead of "" as the last parameter of the IFERROR. The NA cells will be ignored in the chart and the data points will be connected with a line

B6 =IFERROR(SUM(INDIRECT("'"&TEXT(A6,"mm-dd-yy")&"'!C3:E3")),NA())

copied down.

[avidcat]

That's cool. I didn't know that.

Thanks for the help.

Nick