If the cell contains a formula like =IF(A1=0,"",A1), then that cell is
neither empty nor blank. It contains a formula, and the formula returns a
string, "", which while rather short is still a value.

Change "" in the formula to NA(), which produces #N/A in the cell. While
somewhat ugly in the table, it does not appear in a line or XY chart. You
can conditionally format the cell to hide the error.

http://contextures.com/xlCondFormat03.html#Errors

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"wlawler2303" wrote in message
...
Trying to plot a contour map of a film thickness. The substarte is round.
X/Y coordinates are not in a grid so the data table has several empty
cells.
Trying to use 'Tool/Options...', 'Chart' tab and selecting the
'Interpolate'
radio button does nothing. The chart treats the empty cells as zero
value.
If it would interpolate I would be happy.

I also tried this with a grid (square) X/Y table with a couple of empty
cells and again, it did not interploate.