Have your formulas return the #N/A error
Example:
=IF(A1=B1,A1+B1,NA())

XL graphs ignore the NA error, as it is, by definition, not applicable.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"JAbels001" wrote:

I have several graphs put together from data on another tab, however
sometimes this data will come up "N/a" or "No Data" which the graph
recognizes as ZERO. Can this be avoided? I only want the graph to graph
numberical values. Please assist. Thanks!