zero values in charts

[Patty]

Sounds like lots of people have trouble with zero values
in charts. My problem is that I am plotting line charts
from data where there are empty cells. These cells plot
as zero even when I specify under chart options to not
plot empty cells. Sounds like a glitch in the
programming. Any suggestions? I tried changing the cells
to N/a, and changing the cell formatting, but to no avail.

 

[Jerry W. Lewis]

If they plot as zero, the cells are not empty. Most likely, they
contain an IF() formula that is returning "". If it returns #N/A or
equivaletly NA() instead of "", the graph line will will connect
directly from the previous to the next point as though the cell
conaining #N/A did not exist.

Jerry

 

[heather p.]

You can also try telling it to interpolate the data
(Tools>Options>Chart)

 

[Jon Peltier]

Heather -

This will only work if the cells are really blank, unfortunately, not if
they have formulas that look blank.

- Jon

 

[Patty]

Thanks all for the help--indeed, when I clear the cells
their corresponding "zero" datapoints disappear from the
graph! Not sure what was in the cells, though--probably
some copied weirdness from my Access database.