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

2 次查看（过去 30 天）

student_md 2021-2-22

评论： KSSV 2021-2-23

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 2021-2-22

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

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 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)

MATLAB Data Import and Analysis Data Import and Export Standard File Formats Spreadsheets

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

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

Translated by