How to draw a 3D plot from an excel data?

2021 2 22
1 个回答
回答已采纳
更新时间：2021 2 23
5 次查看（30 天）

0 个投票

How to draw a 3D plot from an excel data? Please click for downloading following Excel Data (or find attachment)
(maybe mesh 3d plot or surfc plot)
(First column is x-values, first row is y-values.)

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

 采纳的回答

KSSV
KSSV 2021-2-22

1 个投票

num = xlsread('test3.xlsx') ;
x = num(2:end,1) ;
y = num(1,2:end) ;
Z = num(2:end,2:end) ;
surf(x,y,Z')

3 个评论
显示 1更早的评论 隐藏 1更早的评论

student_md
student_md 2021-2-22
Thank you very much @KSSV.
  • How to draw surfc plot?
The following code doesn' t work.
figure (2)
xi = unique(x) ; nx = length(xi) ;
yi = unique(y) ; ny = length(yi) ;
[X,Y] = meshgrid(xi,yi);
surfc(X,Y,Z');
student_md
student_md 2021-2-22
编辑：student_md 2021-2-22
Dear @KSSV,
Is something wrong in the code?
In fact;
this excel data is values of z=sin(x)*cos(y)
where
x=[-2*Pi, 2*Pi],
y=[-2*Pi, 2*Pi]
KSSV
KSSV 2021-2-23
x=linspace(-2*Pi,2*Pi) ;
y=linspace(-2*Pi,2*Pi) ;
[X,Y] = meshgrid(x,y) ;
Z = sin(x).*cos(y) ; % element by element multiplication
surf(X,Y,Z)

请先登录，再进行评论。

更多回答（0 个）

类别

在 帮助中心 和 File Exchange 中查找有关 2-D and 3-D Plots 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by