您正在关注此问题

您将在关注的内容源中看到更新。
您可能会收到电子邮件，具体取决于您的通信预设项。

How do I plot YY from the excel file data?

1 次查看（过去 30 天）

显示更早的评论

Ashvinder Singh Gill Surmaish Singh Gill 2020-5-12

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/524846-how-do-i-plot-yy-from-the-excel-file-data

⋮

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/524846-how-do-i-plot-yy-from-the-excel-file-data

评论： Ashvinder Singh Gill Surmaish Singh Gill 2020-5-16

采纳的回答： KSSV

Sample Excel Data.xlsx
Capture.PNG

I have data for different factors 1.4, 1.6 and 2.2. How do I plot YY for force reaction and keeping x-axis as displacement on the same chart? The pattern should be as shown in the figure but with yy plot so that the results are more visible.

Appreciate if anyone can assist me. Thank you!

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

采纳的回答

KSSV 2020-5-12

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/524846-how-do-i-plot-yy-from-the-excel-file-data#answer_431974

⋮

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/524846-how-do-i-plot-yy-from-the-excel-file-data#answer_431974

在 MATLAB Online 中打开

data = xlsread("Sample Excel Data.xlsx") ; 
A = data(:,[1 3 5]) ; % pick 1, 3 , 5 column 
K = A(1,:) ;   % factors 
A(1,:) = [] ;
plot(A)

14 个评论
显示 12更早的评论隐藏 12更早的评论

Ashvinder Singh Gill Surmaish Singh Gill 2020-5-12

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/524846-how-do-i-plot-yy-from-the-excel-file-data#comment_845976

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/524846-how-do-i-plot-yy-from-the-excel-file-data#comment_845976

Thanks for reply. Can you show a more comprehensive way of the plots that you get please? How about the plot yy? I am a beginner :)

KSSV 2020-5-13

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/524846-how-do-i-plot-yy-from-the-excel-file-data#comment_846414

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/524846-how-do-i-plot-yy-from-the-excel-file-data#comment_846414

Do you have any demo picture to show?

Ashvinder Singh Gill Surmaish Singh Gill 2020-5-13

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/524846-how-do-i-plot-yy-from-the-excel-file-data#comment_846415

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/524846-how-do-i-plot-yy-from-the-excel-file-data#comment_846415

Refer the Capture.png image. But i need double y-axis.

KSSV 2020-5-13

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/524846-how-do-i-plot-yy-from-the-excel-file-data#comment_846418

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/524846-how-do-i-plot-yy-from-the-excel-file-data#comment_846418

What is displacement and force in the given data?

Ashvinder Singh Gill Surmaish Singh Gill 2020-5-13

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/524846-how-do-i-plot-yy-from-the-excel-file-data#comment_846420

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/524846-how-do-i-plot-yy-from-the-excel-file-data#comment_846420

Refer the attached excel file. For each factor there is displacement and force values. I want to plotyy the force and plot the displacements on x-axis for all the factors 1.4,1.6 and 2.2 on same chart.

KSSV 2020-5-13

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/524846-how-do-i-plot-yy-from-the-excel-file-data#comment_846431

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/524846-how-do-i-plot-yy-from-the-excel-file-data#comment_846431

在 MATLAB Online 中打开

data = xlsread("Sample Excel Data.xlsx") ; 
K = data(1,[1 3 5]) ;   % factors 
data(1,:) = []; 
s1 = data(:,1) ; f1 = data(:,2) ;  
s2 = data(:,3) ; f2 = data(:,4) ; 
s3 = data(:,5) ; f3 = data(:,6) ; 
plot(s1,f1,'r',s2,f2,'b',s3,f3,'g')

Ashvinder Singh Gill Surmaish Singh Gill 2020-5-13

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/524846-how-do-i-plot-yy-from-the-excel-file-data#comment_846438

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/524846-how-do-i-plot-yy-from-the-excel-file-data#comment_846438

Thanks,It works. But, my question is, how do I set another y-axis on the right hand side? with a scale that I can change. Also, How do I change the plots to smooth plot with the points as shown in the picture?

KSSV 2020-5-13

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/524846-how-do-i-plot-yy-from-the-excel-file-data#comment_846440

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/524846-how-do-i-plot-yy-from-the-excel-file-data#comment_846440

在 MATLAB Online 中打开

figure 
yyaxis left 
plot(s1,f1)
yyaxis right
plot(s2,f2)

Ashvinder Singh Gill Surmaish Singh Gill 2020-5-13

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/524846-how-do-i-plot-yy-from-the-excel-file-data#comment_846443

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/524846-how-do-i-plot-yy-from-the-excel-file-data#comment_846443

编辑：Ashvinder Singh Gill Surmaish Singh Gill 2020-5-13

在 MATLAB Online 中打开

figure 
yyaxis left 
plot(s1,f1,'r')
plot(s3,f3,'g')
yyaxis right
plot(s2,f2,'b')

I can't plot s1 & f1 when I change the code like that? What should be done?

KSSV 2020-5-13

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/524846-how-do-i-plot-yy-from-the-excel-file-data#comment_846453

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/524846-how-do-i-plot-yy-from-the-excel-file-data#comment_846453

What do you mean by you cannot plot ?

Ashvinder Singh Gill Surmaish Singh Gill 2020-5-13

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/524846-how-do-i-plot-yy-from-the-excel-file-data#comment_846482

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/524846-how-do-i-plot-yy-from-the-excel-file-data#comment_846482

It's okay I figured it out ready. Thank you for help.

Ashvinder Singh Gill Surmaish Singh Gill 2020-5-13

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/524846-how-do-i-plot-yy-from-the-excel-file-data#comment_846483

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/524846-how-do-i-plot-yy-from-the-excel-file-data#comment_846483

在 MATLAB Online 中打开

data = xlsread("sampleexceldata.xlsx") ; 
K = data(1,[1 3 5]) ;   % factors 
data(1,:) = []; 
s1 = data(:,1) ; f1 = data(:,2) ;  
s2 = data(:,3) ; f2 = data(:,4) ; 
s3 = data(:,5) ; f3 = data(:,6) ; 
figure 
yyaxis right 
plot(s3,f3,'g-*',s2,f2,'b-+')
axis ([0 5 0 90])
ylabel('Force (N)');
yyaxis left
plot(s1,f1,'r-x')
axis ([0 5 0 15])
grid on
title('Force vs Displacement');
xlabel('Displacement (mm)');
ylabel('Force (N)');

Ashvinder Singh Gill Surmaish Singh Gill 2020-5-13

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/524846-how-do-i-plot-yy-from-the-excel-file-data#comment_846484

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/524846-how-do-i-plot-yy-from-the-excel-file-data#comment_846484

编辑：Ashvinder Singh Gill Surmaish Singh Gill 2020-5-13

That is the line of code that I am using to plot that curve, can you assist me on how can i get scatter with smooth lines please? Note i renamed my excel file, thus the naming is different.

Ashvinder Singh Gill Surmaish Singh Gill 2020-5-16