Hi
Having an issue that I don't remmeber encountering in the post. I have an array of data where I am using IF and ISERRROR to return "" if the data point is not available. I've tried making the data return "na" as well as "-" and having the same issue where when charting the data series those values show as 0. Any ideas? (I can force the missing data to return -10 and then fix my axis at 0 but not the most elegant solution!
Having an issue that I don't remmeber encountering in the post. I have an array of data where I am using IF and ISERRROR to return "" if the data point is not available. I've tried making the data return "na" as well as "-" and having the same issue where when charting the data series those values show as 0. Any ideas? (I can force the missing data to return -10 and then fix my axis at 0 but not the most elegant solution!
