Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Ignoring blank cells while locating common text value | Excel Discussion (Misc queries) | |||
Ignoring text and errors with Sumproduct | Excel Worksheet Functions | |||
How can I sort text (in excel) while ignoring articles (e.g., the | New Users to Excel | |||
can you find specific text in a string ignoring any other text | Excel Discussion (Misc queries) | |||
I want a formula to ignore text eg 5mts * 5 ignoring the mts any . | Excel Discussion (Misc queries) |