Forum Discussion
Surface Charts
Hello, I am trying to plot a surface chart where I have blank cells with no data. The chart automatically assumes a zero value for them. I've been trying to change this on "Hidden and Empty Cells Settings" as we do for other 2D plots. However, for some reason, the options "Gaps" is not available, it is gray and unselectable. Option "zero" is selected and the only one available. Could you help me solve this problem, please?
Best regards,
Alice Peccini
3 Replies
nk you for the suggestion Ramiz_Assaf . It is a good solution for future problems. However for this study I really needed to see only the surface, and the filled column under the surface is a problem for me. Thank you anyway. I appreciate it.
With just isolated 'holes' a simple linear interpolation would fill the gap. If more data was missing more sophisticated interpolation would be called for.
