How do I plot YY from the excel file data?

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!

Answer 1

[KSSV]

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

[Ashvinder Singh Gill Surmaish Singh Gill]

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]

Do you have any demo picture to show?

[Ashvinder Singh Gill Surmaish Singh Gill]

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

[KSSV]

What is displacement and force in the given data?

[Ashvinder Singh Gill Surmaish Singh Gill]

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]

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]

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]

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

[Ashvinder Singh Gill Surmaish Singh Gill]

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]

What do you mean by you cannot plot ?

[Ashvinder Singh Gill Surmaish Singh Gill]

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

[Ashvinder Singh Gill Surmaish Singh Gill]

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]

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]

Hello, Can you assist in this please? I am still stuck.