But I dont want #NA in my sheet.
--


Jakob

"Jon Peltier" skrev i melding
...
If the cell is linked, there must be a formula. So replace this:

=A1

with this:

=IF(A1<0,A1,NA())

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

L Young wrote:

Bernard,
Thanks for helping. The problem is the cell is a link and I don't think
I can manipulate the cell b/c of link. Any other way to include answers
in graph greater than '0'.
Linda

"Bernard Liengme" wrote:


Replace zeros by =NA()

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"L Young" <L wrote in message
...

I'm creating a line graph which shows zeros. I do not want to show them