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