Jul 30 2020 06:52 AM
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
Jul 31 2020 10:40 PM
Aug 03 2020 07:54 AM
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.
Aug 03 2020 12:25 PM
With just isolated 'holes' a simple linear interpolation would fill the gap. If more data was missing more sophisticated interpolation would be called for.