# Add x and y Values to z data from excel file

4 views (last 30 days)
Aidan Turner on 9 Mar 2021
Commented: Star Strider on 10 Mar 2021
I have a 37x20 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

Star Strider on 10 Mar 2021
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.
##### 2 CommentsShowHide 1 older comment
Star Strider on 10 Mar 2021
As always, my pleasure!
The plot3 function accepts only vectors, that all must be the same lengths. The surf function requires the third argument to be a matrix, although the first two can be either vectors or matrices (with the appropriate sizes).

### Community Treasure Hunt

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

Start Hunting!