Hello experts,
There are formulas in A1:A100 and B1:B100 that refer to another sheet. The values returned from the another sheet could be blank or a value. If a blank is returned, there should be no point plotted on the graph. On the another hand, the value should be plotted.
My graph now keep graphing all 100 rows even if some of them are blank.
Help please!
There are formulas in A1:A100 and B1:B100 that refer to another sheet. The values returned from the another sheet could be blank or a value. If a blank is returned, there should be no point plotted on the graph. On the another hand, the value should be plotted.
My graph now keep graphing all 100 rows even if some of them are blank.
Help please!