Hi all,
I have a simple line graph with a couple of series on the chart. If a cell does not have any information in it, and is blank, the point will not plot on the graph. However, I have a number of data points that contain if statements (similar to =if(A1<>0,"",45) or something along those lines. Meaning that if A1 is not equal to zero, the cell will be equal to "", or blank. However, because this "blank" cell contains a formula, it now shows up on the chart as a 0 data point rather than not graphing at all as it would if the cell did not contain a formula.
My question is, is there a way to have this "blank" cell that contains a formula not show up on the graph rather than show up as a 0??
Any help would be much appreciated. Thanks everyone!
Bookmarks