zero values in charts

  • Thread starter Thread starter Patty
  • Start date Start date
P

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

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

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