Formula to clean data for Charts

[ChrisNor]

Hi,

I'm currently using IF(A1=0;NA();A1) so that all 0 is set to #N/A... so the charts don't plot the value.

However in some instance I also get #VALUE from one of my formulas... is there a better way to set all value such as 0, #VALUE and other errors to #N/A?

[Andy Pope]

Maybe you could use

IF(OR(A1=0,ISERROR(A1));NA();A1)