MATLAB Answers

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

35 views (last 30 days)
student_md
student_md on 22 Feb 2021
Commented: KSSV on 23 Feb 2021
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.)

Accepted Answer

KSSV
KSSV on 22 Feb 2021
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 Comments
KSSV
KSSV on 23 Feb 2021
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)

Sign in to comment.

More Answers (0)

Community Treasure Hunt

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

Start Hunting!

Translated by