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

2_d grid

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

Best Answer

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