zero values in charts

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

Patty wrote:

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.

You can also try telling it to interpolate the data
(ToolsOptionsChart)

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

Heather -

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

heather p. wrote:
You can also try telling it to interpolate the data
(ToolsOptionsChart)


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

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.


-----Original Message-----
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

Patty wrote:

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.

.