excel and plot

6 次查看（过去 30 天）
Ean Soo
Ean Soo 2011-3-6
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

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

回答（1 个）

Paulo Silva
Paulo Silva 2011-3-6
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)
  1 个评论
Ean Soo
Ean Soo 2011-3-7
For the last part, i would like to plot a vertical line.For example
the range of y is 0 to 0.02
and x is 100.

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Loops and Conditional Statements 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by