Forum Discussion
Solved
Unable to hide blank values in chart
I built a chart in Excel that points to various data points. I can't seem to get the chart to change, however, when I change the options for handling blank values. Here's how I have it currently (to ...
"" is not an empty cell.
Amend you formula:
=IFERROR(1/(1/VLOOKUP()),NA())Then the "Show #NA as an empty cell" should work.
Untested.
"" is not an empty cell.
Amend you formula:
=IFERROR(1/(1/VLOOKUP()),NA())Then the "Show #NA as an empty cell" should work.
Untested.
- That did the trick. Thanks!
