Plot3 to import data from Excel

Hello all,

I am getting problem in plotting a 3D plot , where I am importing data from an excel sheet.Code and data can be seen below; Kindly correct me and needs your guidance.

Thanks in advance :-)

  [x,T,xT] = xlsread('calculations.xlsx','test1','A2:A8');
[x1,T,x1T] = xlsread('calculations.xlsx','test1','B2:B8');
[x2,T,x2T] = xlsread('calculations.xlsx','test1','C2:C8');
[x3,T,x3T] = xlsread('calculations.xlsx','test1','D2:D8');
[x4,T,x4T] = xlsread('calculations.xlsx','test1','E2:E8');
[w,T,wT] =  xlsread('calculations.xlsx','test1','F2:F8');
[w1,T,w1T] = xlsread('calculations.xlsx','test1','G2:G8');
[w2,T,w2T] = xlsread('calculations.xlsx','test1','H2:H8');
b=x(:,1);
c=x1(:,1);
d=x2(:,1);
e=x3(:,1);
f=x4(:,1);
g=w(:,1);
h1=w1(:,1);
i=w2(:,1);
plot3(b,c,d,e,f,g,h1,i,'-.')
zlim([0 60]);
xlim([0  8 ]);
ylim([0 2]);
Fig = figure(1); 
set(Fig, 'color','white'); 
xlabel( 'Image Numbers');
ylabel( 'NC');
zlabel('Quality Factors');

[Walter Roberson]

No worksheet named 'test1' in the file.

[marie lasz]

Oh sorry it didn't save the name.

Answer 1

[KSSV]

T = xlsread('calculations.xlsx') ;
plot(T(:,1),T(:,2:end))

[marie lasz]

I need a 3D plotting.

[KSSV]

surf(T(:,2:end))

[Walter Roberson]

T = readmatrix('https://www.mathworks.com/matlabcentral/answers/uploaded_files/649670/calculations.xlsx');
surf(T(:,2:end))