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

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.
 
J

Jon Peltier

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I ignore Graphs zero values. 10
Hiding zero values in charts 1
How to eliminate zero values on graphs when formula calculates 0? 3
negative/zero values on logarithmic plot warning 4
Graph points going to zero 4
Surpressing plot of blank cells 3
Ignor zero values 3
Hiding zeros in dynamic charts 3

Top