How to plot 3d surface plot from excel data

49 views (last 30 days)
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')

Accepted Answer

Tala
Tala on 29 Mar 2022
Edited: Tala on 29 Mar 2022
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)

More Answers (0)

Tags

Products


Release

R2022a

Community Treasure Hunt

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

Start Hunting!