• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Ignore plotting zeros

In the attached file, I have numbers up to 03.27.2015. Beyond that I have zeros. I want to plot this entire series, but I want the graph to ignore any zeros, i.e. don't plot any zeros.

I think I have done this before, but I just can't remember how. Is this possible?
 

Attachments

  • Ignore Plotting Zeros.xlsx
    13.4 KB · Views: 0
Put the formula =NA() in cell N2
Copy across

or simply clear the cells N2:AA2

It is plotting a line at zero as it has a zero in the cells
 
Back
Top