Plotting a 3D surface model with colours from excel

Question

Najim Popalzai 2020-11-30

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/669013-plotting-a-3d-surface-model-with-colours-from-excel

回答： Star Strider 2020-11-30

dagslysdata.xlsx

Hey

I need help for plotting a 3D surface model with colours based on my z axis. I have imported my data from excel into Matlab, however I am quite new to this software, so I am bit confused which commandoes should be used. The excel file is shared :)

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Star Strider 2020-11-30

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/669013-plotting-a-3d-surface-model-with-colours-from-excel#answer_560448

在 MATLAB Online 中打开

I am not certain what result you want.

One option:

T1 = readtable('dagslysdata.xlsx', 'HeaderLines',3);
Xv = linspace(min(T1.X), max(T1.X), 50);
Yv = linspace(min(T1.Y), max(T1.Y), 50);
[Xm,Ym] = ndgrid(Xv, Yv);
Zm = griddata(T1.X,T1.Y,T1.Z, Xm,Ym, 'natural');
figure
surf(Xm, Ym, Zm)
view(-30,30)

Another option:

Zm = griddata(T1.X,T1.Y,T1.Z, Xm,Ym, 'nearest');
figure
surf(Xm, Ym, Zm)
view(-30,30)

See the documentation on griddata for a full description of what it does, and linspace to understand how to create the ‘Xv’ and ‘Yv’ vectors (that then use ndgrid to create the ‘Xm’ and ‘Ym’ matrices) to get the resolution you want.