MS Excel does not interpolate empty cells

[wlawler2303]

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.

 

[Jon Peltier]

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