Forum Discussion
Need Help with Line Chart Not Recognizing Blank Cells
I need my charts to not drop down to zero whenever they read a blank cell and I am unsure how to do this. I tried to right click the graph and "gaps" is already selected. I think my sheet is recogniz...
conpage
Hey, you can use an array formula to sort/remove the gaps between cells for your graph.
Like these:
Formula:
=IF(ROWS(D$1:D1)>COUNTA(G:G),"",INDEX(G:G,SMALL(IF(G$3:G$13<>"",ROW(G$3:G$13)),ROWS(D$1:D1))))
then fill the formula below, by dragging outside selection to extend the series of formula.