Graphing 0 values from blank cells
 

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.

Graphing 0 values from blank cells
 

change formula to:

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



"Mike" wrote:

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.

Graphing 0 values from blank cells
 

Mike,
can you try

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

-kc
-click YES if this works!

"Mike" wrote:

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.

Graphing 0 values from blank cells
 

Hi,
if(INDIRECT("'Enter data'!i$19")="","",INDIRECT("'Enter data'!i$19"))

"Mike" wrote:

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.

Graphing 0 values from blank cells
 

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.

"cm" wrote:

change formula to:

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



"Mike" wrote:

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.

Graphing 0 values from blank cells
 

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.

"Eduardo" wrote:

Hi,
if(INDIRECT("'Enter data'!i$19")="","",INDIRECT("'Enter data'!i$19"))

"Mike" wrote:

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.

Graphing 0 values from blank cells
 

=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.





Mike wrote:

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.

--

Dave Peterson

Graphing 0 values from blank cells
 

Dave,
Thanks. 0's are removed from graph.
Thanks to all for quick help.
Mike


"Dave Peterson" wrote:

=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.





Mike wrote:

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.

--

Dave Peterson