excel and plot
1 Ansicht (letzte 30 Tage)
Ältere Kommentare anzeigen
Hie guys, i have an excel file which have 2 column with 1600 rows. I use this command to read both entire row.
fileName= 'data.xls';
a=xlsread(fileName);
x=a(:,1);
y=a(:,2);
plot(x,y)
Is it possible for me to just read the data for column x from 1 to 200? Is it possible to add another plot of straight line which is x=100 in the same plot?if yes, how to implement that? thank you. Regard EAN
0 Kommentare
Antworten (1)
Paulo Silva
am 6 Mär. 2011
x(1:200) %all data from column 1 to 200
hold on %this will allow more lines on the same axes
The last question I don't know exactly what you want
line([100 100],get(gca,'Ylim')) %vertical line x=100
line(get(gca,'Xlim'),[x(100) x(100)]) %horizontal line x(100)
Siehe auch
Kategorien
Mehr zu Histograms finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!