excel and plot
3 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
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 commentaires
Réponses (1)
Paulo Silva
le 6 Mar 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)
Voir également
Catégories
En savoir plus sur 2-D and 3-D Plots dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!