Surface Plot Excel Data

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.

[KSSV]

Attach excel file....not as image.

Answer 1

[KSSV]

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

[Aditya Chaugule]

Thanks, the Transpose worked !!

[KSSV]

Thanks is accepting and/or voting the answer ...:)

[JEONGMIN KIM]

thanks man

[Hammad Masood]

I tried to do the above but got the following error,

Error using surf (line 71)

Data dimensions must agree.

Tried transposing but that isn't working also. Please help.

My file is also attached.

[KSSV]

T = readtable('https://in.mathworks.com/matlabcentral/answers/uploaded_files/886870/SA.xlsx') ;
z = table2array(T) ;
surf(z)

[sameer kumar]

How to restrict boundary?