Forum Discussion
Blank cells show up as zeros in chart
Hello, I'm taking simple averages of my data (e.g. =AVERAGE(B3:Q3)) and then plotting them as a line in a scatter plot. However, there are many gaps in my data, so my averages often return #DIV/0...
Perhaps you copy/pasted as values cells with empty texts (=""). Even empty text is not visible and have zero length it's still the text. Thus the cell is not blank. If so - yes, you need to delete such empty texts.
A formula that looks like =IF(something,"") that returns "" is NOT an empty cell, and will be plotted as a zero value. Change it to =IF(something,NA()), and you will get #N/A in the cell, and #N/A can be plotted as if it is blank.