How to Create a Surface Plot from Table Data Imported from Excel
96 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Michaela Byrne
le 3 Mar 2022
Commenté : Michaela Byrne
le 4 Mar 2022
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?
0 commentaires
Réponse acceptée
Scott MacKenzie
le 3 Mar 2022
Modifié(e) : Scott MacKenzie
le 3 Mar 2022
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.
Plus de réponses (1)
Walter Roberson
le 3 Mar 2022
x = PlotTestS1.TetherK;
y = PlotTestS2.TetherCn
z = table2array(PlotTestS3) ;
surf(x, y, z, 'edgecolor', 'none')
0 commentaires
Voir également
Catégories
En savoir plus sur Spreadsheets dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!