How to hide zero values in graphs using Mircosoft excel 2003?

  • Thread starter Thread starter Ravi.K.Rao
  • Start date Start date
R

Ravi.K.Rao

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
 
Back
Top