I have read how to trick excel into ignoring text within a series range by
using =NA(). Is there a way to ignore the text in a xy scatter chart (i.e.
does not plot as 0) but still keeps the text visible. For example on certain
days a well is not sampled and so is left with "NM". I still want the "NM"
to show so i can use that data in a report but would like to graph it as
well. I realize that I could copy the data to a new location and get rid of
the text there..however, my data is dynamically produced and I would rather
not have to manual update my graph in that manner