3D plot from excel data

Question

Francesco Marchione 2021-4-22

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/810390-3d-plot-from-excel-data

评论： Star Strider 2023-5-12

采纳的回答： Star Strider

prova_stress.xlsx

Hello,

I have an excel sheet cointaining x,y,z data in three columns (see attached file).

I would like to plot a 3D graph from this data.

Thanks everyone

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

请先登录，再进行评论。

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

Answer 1

Star Strider 2021-4-22

3
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/810390-3d-plot-from-excel-data#answer_682245

在 MATLAB Online 中打开

Try this:

T1 = readtable('https://www.mathworks.com/matlabcentral/answers/uploaded_files/593500/prova_stress.xlsx', 'VariableNamingRule','preserve');

Q1 = T1(1:25,:);

VarNames = T1.Properties.VariableNames;

x = T1{:,1};

y = T1{:,2};

z = T1{:,3};

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

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

N = 25;

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

Warning: Duplicate data points have been detected and removed - corresponding values have been averaged.

figure

surfc(Xm, Ym, Zm)

grid on

xlabel(VarNames{1})

ylabel(VarNames{2})

zlabel(VarNames{3})

.

6 个评论
显示 4更早的评论隐藏 4更早的评论

Mohammed Saifuddin Ustad 2023-5-12

Hey thanks for the help so i have another question my data is mentioned below.

However i was wondering whether there is a way to make my plot smoother, i have tried cubic interpolation and it helps a little. Though i am not able to use pchip and i heard that one would be best. Also can i make the little boxes disappear thanks. Help with this please.

Inserting my data, code and a snippet of the plot.

thanks

my data

0,0,0

0,200,0.236

0,400,0.304

0,600,0.351

0,800,0.387

0,1000,0.404

1,0,0.053

1,200,0.275

1,400,0.350

1,600,0.401

1,800,0.444

1,1000,0.478

2,0,0.118

2,200,0.276

2,400,0.346

2,600,0.398

2,800,0.439

2,1000,0.475

3.5,0,0.213

3.5,200,0.299

3.5,400,0.358

3.5,600,0.409

3.5,800,0.436

3.5,1000,0.478

5,0,0.305

5,200,0.337

5,400,0.401

5,600,0.431

5,800,0.476

5,1000,0.494

7.5,0,0.452

7.5,200,0.481

7.5,400,0.510

7.5,600,0.517

7.5,800,0.558

7.5,1000,0.584

my code using cubic

T1 = readtable('solarcol3.csv');

VarNames = T1.Properties.VariableNames;

x = T1{:,1};

y = T1{:,2};

z = T1{:,3};

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

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

N = 25;

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, 'cubic'); % specify cubic interpolation

figure

surfc(Xm, Ym, Zm)

colorbar

grid on

xlabel('Wind Velocity (m/s)')

ylabel('Heat Flux (W/m2)')

zlabel('Mass Flow Rate (kg/s)')

Image of plot

Mohammed Saifuddin Ustad 2023-5-12

okay that i have tried but do you have any idea with pchip interpolaton or any other interpolation that would make this plot better

and sure i will keep that in mind

Star Strider 2023-5-12

I don’t. I looked at other interpolation functions, and they all have essentially the same options, with interp2 also having 'cubic' and 'makima'.

请先登录，再进行评论。

3D plot from excel data

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

采纳的回答

6 个评论
显示 4更早的评论隐藏 4更早的评论

更多回答（0 个）

另请参阅

类别

标签

产品

Community Treasure Hunt

3D plot from excel data

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

采纳的回答

6 个评论 显示 4更早的评论隐藏 4更早的评论

更多回答（0 个）

另请参阅

类别

标签

产品

Community Treasure Hunt

WeChat

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

6 个评论
显示 4更早的评论隐藏 4更早的评论