Custom Number format to not show zeros and #N/A

[Chris Macro]

I have the following custom cell format that handles hiding zeros, however I would also like to hide #N/A too. I am graphing this data and I want the data labels to appear non-existent if there is a 0 or #N/A being graphed. I do not want to delete the data labels as in the future there could be numerical values in the cells.

Current Custom Format:

0.00;-0.00;;@

 

[Jonmo1]

You might be better off in the long run adjusting your formula to return a 0 insetad of #N/A

Can you post that formula?

 

[Chris Macro]

That's what I had originally, but line graphs, graph zeros and they do not graph #N/As

 

[Chris Macro]

Hey JomMo I believe I figured it out. I added an IF() statement to toggle between N/A and 0 based on if I want to graph a bar chart or a line chart. Thanks for your help!