3D surface plot from imported 2D excel array

11 次查看（过去 30 天）
joe pearson
joe pearson 2018-3-2
编辑： joe pearson 2018-3-3
New to Matlab. Im sure this is answered somewhere already, but I can't manage to find it; I have a 2D array of experimental data tabulated in excel. 1st row and column are varied parameters, and I measure the corresponding amplitudes in the matrix. Importing the table to Matlab is simple. I would then like to plot a 3D surface of the 1st row (x) vs. 1st column (y), for the amplitudes in the matrix. This is very straightforward in excel, but the plots look terrible. Thanks in advance for the help.

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

采纳的回答

Star Strider
Star Strider 2018-3-2
Try this:
[D,S,R] = xlsread('ExampleArray.xls');
figure(1)
ribbon(D(:,1), D(:,2:end))
grid on
[X,Y] = meshgrid((1:size(D,2)-1), D(:,1));
Z = D(:,2:end);
figure(2)
surf(X, Y, Z)
grid on
  8 个评论
显示 6更早的评论
joe pearson
joe pearson 2018-3-3
编辑：joe pearson 2018-3-3
That's almost what I wanted. I finally figured out how it works. Thanks again for all the help!! This is the code I am using, in case the next person to come along finds it useful;
[D,S,R] = xlsread('ExampleArray.xls');
Z = D(2:end,2:end);
M = max(max(Z));
figure(1)
X = D(1,2:end);
Y = D(2:end,1);
x1 = min(X);
x2 = max(X);
y1 = min(Y);
y2 = max(Y);
surf(X,Y,Z)
axis manual
xlim([x1 x2])
ylim([y1 y2])
colormap parula
shading interp
colorbar
caxis([0 M])
%view(2)
uncommenting the view(2) makes a nice psuedo 3D view

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Creating, Deleting, and Querying Graphics Objects 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by