How to Create a Surface Plot from Table Data Imported from Excel

24 次查看（过去 30 天）
Michaela Byrne
Michaela Byrne 2022-3-3
评论： Michaela Byrne 2022-3-4
I am trying to create a surface plot for the excel table shown in the image below using the "surf" function. TetherK and TetherC are my inputs. Power is my output (the white cells). I can't seem to get the surf fucntion to work. I imported the data and have a table in MATLAB for TetherK, TetherC, and my Output (shown below). What do I need to do so that I can make a surface plot from tables in MATLAB?

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

采纳的回答

Scott MacKenzie
Scott MacKenzie 2022-3-3
编辑：Scott MacKenzie 2022-3-3
Ran in:
Given some test data (attached) similar to yours...
... a surface plot can be created thus...
M = readmatrix('testdata.xlsx');
[X,Y] = meshgrid(M(1,2:end),M(2:end,1));
Z = M(2:end,2:end);
surf(X,Y,Z);
The test data are random values. Hopefully, your plot will look more interesting.
  1 个评论
Michaela Byrne
Michaela Byrne 2022-3-4
That worked, thanks! I'm including pictures of what I did in MATLAB to get it to work in case anyone else has a similar question to what I had and wants to see what I did.

请先登录，再进行评论。

更多回答（1 个）

Walter Roberson
Walter Roberson 2022-3-3
x = PlotTestS1.TetherK;
y = PlotTestS2.TetherCn
z = table2array(PlotTestS3) ;
surf(x, y, z, 'edgecolor', 'none')

类别

在 Help Center 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息

标签

产品


版本

R2021b

Community Treasure Hunt

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

Start Hunting!

Translated by