Supress zero on Table Chart

[martinofyre]

I need to suppress data points that are zero on a chart linked to a table.

I have achieved this with a standard chart using NA() in the IF statement that generates the data to be charted.
The NA() generates a #N/A in the data which a standard chart ignores, this does not seem to work with a chart generated from a table of the same data.

Formula: =IF(PV!O5>0,1*$DN9,NA())

Thanks