How to plot 3d surface plot from excel data

45 次查看（过去 30 天）

显示更早的评论

Vishal Guggari 2022-3-29

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1683549-how-to-plot-3d-surface-plot-from-excel-data

编辑： Tala 2022-3-30

采纳的回答： Tala

Data set.xlsx

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')

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

Tala 2022-3-29

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1683549-how-to-plot-3d-surface-plot-from-excel-data#answer_929869

编辑：Tala 2022-3-29

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)

2 个评论
显示无隐藏无

Vishal Guggari 2022-3-29

Thanks alot.

Tala 2022-3-29

编辑：Tala 2022-3-30

anytime

请先登录，再进行评论。

类别

MATLAB Graphics 2-D and 3-D Plots Surfaces, Volumes, and Polygons Surface and Mesh Plots

在 Help Center 和 File Exchange 中查找有关 Surface and Mesh Plots 的更多信息

产品

MATLAB

版本

R2022a

Community Treasure Hunt

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

Start Hunting!

Translated by