I've got sheets that automatically generate line graphs, but I've got a problem - when a cell contains an equation that blanks out the cell (e.g., =IF(A1="","",1)), what I'd like is for a point and attached line to that point not to be displayed for the point represented by that cell (like is the case if the cell is empty). Does anyone have any way to make the blank cell with the equation behave like an empty cell when it comes to graphing? I've tried TOOLS>OPTIONS>CHART>Active Chart>"Plot visible cells only", but that doesn't do the trick.
Any help is appreciated.
Dale
Any help is appreciated.
Dale