Cell with zero to appear as empty

[Guest]

Is it possible in Excel 2003 to make a cell with a formula, that has the
outcome zero, to appear as an empty cell? I am making a line graphic but I
want the cells with zero not added in the graphic. How is this possible?

 

[Bob Phillips]

Tools>Options>View uncheck Zero values.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[RagDyer]

Change your formulas to return the #N/A error instead of 0, which XL will
not graph.

=IF(SUM(A1:A20),SUM(A1:A20),#N/A)

=IF(A20*A10,A20*A10,#N/A)

 

[Guest]

Thanks, that was just the answer I was looking for!

 

[RagDyeR]

Thanks for the feed-back.

 

[Guest]

Dear Bob,

Was already aware of that option, but then zero still appears in a graphic.
The answer of RagDyer gave me what I needed. Thanks for the effort, though!