import data and plat a 3D
2 views (last 30 days)
Show older comments
I do have a excel file with 3 columns (x y z). I wanna import them to Matlab, and plot a nice surface Plot.i might have to interpolate?
2 Comments
Rik
on 20 Dec 2019
If it is a full grid of x and y, there will be no need for interpollation. Can you share your actual data, or a functional equivalent?
Answers (2)
Rik
on 20 Dec 2019
No interpollation required, just a conversion to a 2D matrix. You can adapt the syntax of accumarray if you do have any missing values (by default it will fill with 0).
num=xlsread('test1.xlsx');
x=num(:,1);
y=num(:,2);
P=num(:,3);
%find the unique x and y values and use them as indices to fill the Z
[X,~,x_]=unique(x);
[Y,~,y_]=unique(y);
Z=accumarray([x_,y_],P);
[X,Y]=ndgrid(X,Y);
surf(X,Y,Z)
10 Comments
Rik
on 6 Jan 2020
On a conceptual level, what would you do? If you needed to do it on paper, what would your approach be?
ME
on 20 Dec 2019
I think you are correct about the need to interpolate. You could try having a read of the link below - that should give you some good pointers.
0 Comments
See Also
Categories
Find more on Surface and Mesh Plots in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!