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 A cell with "" is not considered empty. You can use:
=IFERROR(G11/G12,NA())
It will return an #N/A! error that will be taken as a gap in the line.