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

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?

Answer 1

[Scott MacKenzie]

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.

[Michaela Byrne]

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.

Answer 2

[Walter Roberson]

x = PlotTestS1.TetherK;
y = PlotTestS2.TetherCn
z = table2array(PlotTestS3) ;
surf(x, y, z, 'edgecolor', 'none')