I am trying to ignore N/A fields in a line chart and the hidden and empty cells options are grayed out? How can I ignore N/A fields in the chart in this situation? Thanks in advance for your help.
I am trying to ignore N/A fields in a line chart and the hidden and empty cells options are grayed out? How can I ignore N/A fields in the chart in this situation? Thanks in advance for your help.
Based on the file that you posted here you should be able to use the ISERROR (works for all Excel error types) or ISNA (works for the specific N/A error type) function to help eliminate those values from showing up in your chart. To do this just follow this syntax and replace the formulas as such.
=IF(ISERROR(Your Formula Here),"Whatever you want the cell to show",(Your Formula Here))
So, for example if you want the cell to remain blank if there is an error showing up you would do the following:
=IF(ISERROR(A1+B1),"",(A1+B1))
Or
=IF(ISNA(A1+B1),"",(A1+B1))
So, if there is an error returned at all it will replace the cell with a blank instead of the error type. Once you invoke that on your formula, just copy down and you should be good to go.
Hope that helps.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks