Cell with zero to appear as empty
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)
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Ewout" wrote in message
...
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?
--
Ewout
|