How to plot 3d surface plot from excel data

clc

clear all

T = readmatrix('C:\Users\visha\Desktop\Data set.xlsx')

x = T(:,1)

y = T(:,2)

z = T(:,3)

[X,Y]=meshgrid(x,y)

surf(X,Y,z)

xlabel('X')

ylabel('Y')

zlabel('Plastic Strain')

Answer 1

[Tala]

Source is Here.

Use this:

T = readmatrix('Data.xlsx');

x = T(:,1);

y = T(:,2);

z = T(:,3);

[Ux,iax,ixx] = unique(x);

[Uy,iay,ixy] = unique(y);

N = 25; % adjust

xv = linspace(min(x), max(x), N);

yv = linspace(min(y), max(y), N);

[Xm,Ym] = ndgrid(xv, yv);

Zm = griddata(x, y, z, Xm, Ym);

figure

surfc(Xm, Ym, Zm)

[Vishal Guggari]

Thanks alot.

[Tala]

anytime