Surface Charts

%3CLINGO-SUB%20id%3D%22lingo-sub-1556110%22%20slang%3D%22en-US%22%3ESurface%20Charts%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1556110%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%20I%20am%20trying%20to%20plot%20a%20surface%20chart%20where%20I%20have%20blank%20cells%20with%20no%20data.%20The%20chart%20automatically%20assumes%20a%20zero%20value%20for%20them.%20I've%20been%20trying%20to%20change%20this%20on%20%22Hidden%20and%20Empty%20Cells%20Settings%22%20as%20we%20do%20for%20other%202D%20plots.%20However%2C%20for%20some%20reason%2C%20the%20options%20%22Gaps%22%20is%20not%20available%2C%20it%20is%20gray%20and%20unselectable.%20Option%20%22zero%22%20is%20selected%20and%20the%20only%20one%20available.%20Could%20you%20help%20me%20solve%20this%20problem%2C%20please%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20regards%2C%26nbsp%3B%3C%2FP%3E%3CP%3EAlice%20Peccini%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1556110%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1559995%22%20slang%3D%22en-US%22%3ERe%3A%20Surface%20Charts%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1559995%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F744813%22%20target%3D%22_blank%22%3E%40AlicePeccini%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMaybe%20you%20can%20try%20to%20use%20a%203D%20column%20plot%3C%2FP%3E%3CP%3Esee%20the%20attached%20file%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1562862%22%20slang%3D%22en-US%22%3ERe%3A%20Surface%20Charts%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1562862%22%20slang%3D%22en-US%22%3E%3CP%3Enk%20you%20for%20the%20suggestion%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F746148%22%20target%3D%22_blank%22%3E%40ramizassaf%3C%2FA%3E%26nbsp%3B.%20It%20is%20a%20good%20solution%20for%20future%20problems.%20However%20for%20this%20study%20I%20really%20needed%20to%20see%20only%20the%20surface%2C%20and%20the%20filled%20column%20under%20the%20surface%20is%20a%20problem%20for%20me.%20Thank%20you%20anyway.%20I%20appreciate%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1563520%22%20slang%3D%22en-US%22%3ERe%3A%20Surface%20Charts%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1563520%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F744813%22%20target%3D%22_blank%22%3E%40AlicePeccini%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWith%20just%20isolated%20'holes'%20a%20simple%20linear%20interpolation%20would%20fill%20the%20gap.%26nbsp%3B%20If%20more%20data%20was%20missing%20more%20sophisticated%20interpolation%20would%20be%20called%20for.%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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

 

@AlicePeccini 

Maybe you can try to use a 3D column plot

see the attached file

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.

 

 

 

 

@AlicePeccini 

With just isolated 'holes' a simple linear interpolation would fill the gap.  If more data was missing more sophisticated interpolation would be called for.