Plot3 to import data from Excel

3 次查看（过去 30 天）
marie lasz
marie lasz 2021-6-11
评论： Walter Roberson 2021-6-11
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');

请先登录，再回答此问题。

回答（1 个）

KSSV
KSSV 2021-6-11
T = xlsread('calculations.xlsx') ;
plot(T(:,1),T(:,2:end))
  3 个评论
显示 1更早的评论
Walter Roberson
Walter Roberson 2021-6-11
Ran in:
T = readmatrix('https://www.mathworks.com/matlabcentral/answers/uploaded_files/649670/calculations.xlsx');
surf(T(:,2:end))

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 2-D and 3-D Plots 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by