Graph while ignoring text but not changing text to #NA
 

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

Graph while ignoring text but not changing text to #NA
 

Use your original range for the tabular report, then make a second range,
linked to the first but with corrections like NA(), and use this as your
chart source data.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"haruun" wrote in message
...
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