N-D grid from excel columns-2-D grid

Question

chiara 2014-6-6

回答： Sara 2014-6-6

Hello everyone I have a file excel with two columns x,y and 2110 rows.

I plot all the couples xi,yi on a graph and now I would like to make a 2-D grid.

If then I have N columns how can I extend it to an N-grid

Can someone help me

Answer 1

Sara 2014-6-6

First, read the whole file:

A = xlsread('myfile.xlsx','A1:N2110');  % replace N2110 with the last point in your file

If all the column from 2 to N are function of the first column and you want them on the same plot:

figure
hold on
for i = 2:size(A,2)
   plot(A(:,1),A(:,i))
end

or on separate plots:

for i = 2:size(A,2)
   figure
   plot(A(:,1),A(:,i))
end