Plot3 to import data from Excel

1 view (last 30 days)
marie lasz
marie lasz on 11 Jun 2021
Commented: Walter Roberson on 11 Jun 2021
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');
  2 Comments
Walter Roberson
Walter Roberson on 11 Jun 2021
No worksheet named 'test1' in the file.
marie lasz
marie lasz on 11 Jun 2021
Oh sorry it didn't save the name.

Sign in to comment.

Answers (1)

KSSV
KSSV on 11 Jun 2021
T = xlsread('calculations.xlsx') ;
plot(T(:,1),T(:,2:end))
  3 Comments
KSSV
KSSV on 11 Jun 2021
surf(T(:,2:end))
Walter Roberson
Walter Roberson on 11 Jun 2021
T = readmatrix('https://www.mathworks.com/matlabcentral/answers/uploaded_files/649670/calculations.xlsx');
surf(T(:,2:end))

Sign in to comment.

Categories

Find more on 2-D and 3-D Plots in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!