excel and plot
3 views (last 30 days)
Show older comments
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 Comments
Answers (1)
Paulo Silva
on 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)
See Also
Categories
Find more on 2-D and 3-D Plots in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!