when i chart a series of data in which some of the data are from a equation of =If(a=b, 123, ""). Although the cell shows a "" but in chart the line will drop to zero. I want it to be a missing data and the line could interpolate this point. How could i do that? thank you very much.
Bookmarks