MATLAB Answers

0

Surface Plot Excel Data

Asked by Aditya Chaugule on 12 Jun 2019
Latest activity Commented on by KSSV
on 13 Jun 2019
I have a file in excel with varying data in x, y & z independent of each other. How do I surface plot these ?? The A column is X data (shown in black), Row 1 is Y data (shown in Red) and the Z data is found out for each corresponding values of X and Y experimentally(shown in blue).
I did import the X and Y data from excel to matlab, also one of the Z data (column B) But not the entire Z data (blue). Any suggestions.
Quest.png

  1 Comment

KSSV
on 12 Jun 2019
Attach excel file....not as image.

Sign in to comment.

1 Answer

Answer by KSSV
on 12 Jun 2019

num = xlsread(myfile) ;
x = num(:,1) ;
y = num(1,:) ;
Z = num(2:end,2:end) ;
surf(x,y,Z) % if throws error trnspose Z

  2 Comments

Thanks, the Transpose worked !!
KSSV
on 13 Jun 2019
Thanks is accepting and/or voting the answer ...:)

Sign in to comment.