I am using MS Excel 2003. While creating a linked data base, I have many
values returned as zero. When I create a graph, I do not want the graphs to
plot the zero values. Is there a method to do this without deleting any zero
values?

I know easy methos is to delete the zero values and leave it blank. But as
these are linked from other data base, I do not want to search an delte.

Replace 0 or "" in your lookup formulas with NA(). This returns the #N/A
error, which is not plotted in a marker-type chart (line or XY chart).

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


"Ravi.K.Rao" wrote in message
...
I am using MS Excel 2003. While creating a linked data base, I have many
values returned as zero. When I create a graph, I do not want the graphs
to
plot the zero values. Is there a method to do this without deleting any
zero
values?

I know easy methos is to delete the zero values and leave it blank. But as
these are linked from other data base, I do not want to search an delte.