Not wanting Zero Values displayed in Graphs

[Paul Whitaker]

I have looked at other posts on this subject and the NA() solution does the trick of removing any reference on a Graph.

The problem I now have is that some of the data source is dependant on the values from cells in the row above. Using an @SUM calculation returns #NA when the formula refers to a cell range which contains #NA in it.

How can I get zero values not displayed in a graph and also use a calculation which refers to cells that could contain #NA ? Any suggestion would be most welcome

Paul

 

[cata2200]

Hi Paul

For #na, just make an "error handling" formula inside your formula, using ISERROR function.

For Zero values... wait.

Regards Catalin