For graphing purposes, I would like to know if it is possible to tell Excel to treat certain text value e.g. "alpha" in a cell as =na(). So that it will print no line instead of zeros (which is what it currently does when it reads text). Thanks!
For graphing purposes, I would like to know if it is possible to tell Excel to treat certain text value e.g. "alpha" in a cell as =na(). So that it will print no line instead of zeros (which is what it currently does when it reads text). Thanks!
Is your source data table comprised of formulas or hard coded values?
Don't just use the answers provided for you. Try to understand how it works by reverse engineering or asking about it.
Please mark the thread as [SOLVED] (Thread Tools->Mark thread as Solved) when answered.
If you're happy with an answer given, please click the * under the person's name to boost their reputation.
hard coded values. thanks
Create a second helper table with formulas that references the previous table cell-for-cell. Adjust the following formula as needed:
=IF(B2="alpha",NA(),B2)
If you're looking to replace any text values with NA use:
=IF(ISTEXT(B2),NA(),B2)
Adjust your chart's source data to the helper table.
Unfortunately that is the only way you can accomplish what you want without creating a macro to replace the values.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks