MATLAB: Add x and y Values to z data from excel file

cartesianmatrixscalar point map

I have a 37×20 array in excel which corresponds to the magnitude of z value at each point. I would like to add the following x and y values to create a 3D matrix.

x=linspace(0,100,20)

y=linspace(0,28,37)

The resulting matrix would have coordinates of element 1 (0,0,(Value from z array))

Any help is greaty appreciated

Best Answer

It looks as though that would do exactly what you want.

For example, this:

z = rand(37,20);                                    % Use Your ‘z’ Matrix Here
x=linspace(0,100,20);
y=linspace(0,28,37);
figure
surf(x, y, z)
grid on
xlabel('x')
ylabel('y')
zlabel('z')

will plot it appropriately.

Related Solutions

MATLAB: How to plot x y z coordinates

One way to visualize your data would be

 plot3(X,Y,Z, 'o')

MATLAB: How to get 2d line of surface plot section view

Try this:

[X,Y,Z] = peaks(50);                                            % Create Surface Data
figure
surf(X,Y,Z)
grid on
xlabel('X')
ylabel('Y')
zlabel('Z')
title('Surface Plot')
Xval = 0.5;
Yp = interp1(X(1,:), Y.', Xval);
Zp = interp1(X(1,:), Z, Xval);
figure
plot(Yp, Zp, '-r')
grid
xlabel('Y')
ylabel('Z')
title(sprintf('Slice Through Surface At X = %.3f', Xval))

Since the ‘X’ value you want may not correspond to an existing ‘X’ value in the computed surface, this interpolates to produce the appropriate vectors at any ‘X’ value within the defined range of the surface.

Note that here the ‘Y’ matrix is transposed, since it was apparently created by meshgrid. It may be necessary to experiment by transposing the matrices depending on the particular surface created, and how they were defined (meshgrid or ndgrid, since their outputs are transposes of each other). My code here appears to work with the peaks function I chose to test it.

Best Answer

Related Solutions

MATLAB: How to plot x y z coordinates

MATLAB: How to get 2d line of surface plot section view

Related Question