Graphing 0 values from blank cells

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

My formula is:
=INDIRECT("'Enter data'!i$19")

i19 in the "Enter data" sheet referenced in the formula is blank, but the
formula returns a "0" in the cell. I do not want a "0". I just want it
blank. And it is graphing a "0" value when I create a graph based on the
worksheet with the formulas.

Any suggestions on how I can prevent/change this from happening so that the
"0" is not returned or graphed.
Thank you.
 
Mike,
can you try

=IF(INDIRECT("'Enter data'!i$19")=0,"",INDIRECT("'Enter data'!i$19"))

-kc
-click YES if this works!
 
1/2 way there. Thank you.

This formula removed the "0" from the spreadsheet, but the "0" is still
graphed as a 0 value in the graph.

I even went back and re-selected the data, saved the file, closed and
reopened.

What next?

Thank you.
 
This formula with the quadruple quotes after the equal sign did not remove
the 0's from the graph. It removed the 0's from the spreadsheet, but it is
still graphing 0's on the graph.

The data selected for the graph does contain these cells that I've changed,
but still graphing 0's.

Any other ideas?

Thanks.
 
=if(INDIRECT("'Enter data'!i19")="",na(),INDIRECT("'Enter data'!i19"))

If you don't like the N/A's, you could hide them using conditional formatting.
 
Back
Top