Surface Plot Excel Data
显示 更早的评论
I have a file in excel with varying data in x, y & z independent of each other. How do I surface plot these ?? The A column is X data (shown in black), Row 1 is Y data (shown in Red) and the Z data is found out for each corresponding values of X and Y experimentally(shown in blue).
I did import the X and Y data from excel to matlab, also one of the Z data (column B) But not the entire Z data (blue). Any suggestions.
回答（1 个）
KSSV
2019-6-12
num = xlsread(myfile) ;
x = num(:,1) ;
y = num(1,:) ;
Z = num(2:end,2:end) ;
surf(x,y,Z) % if throws error trnspose Z
6 个评论
Aditya Chaugule
2019-6-13
KSSV
2019-6-13
Thanks is accepting and/or voting the answer ...:)
JEONGMIN KIM
2021-6-9
thanks man
Hammad Masood
2022-2-7
I tried to do the above but got the following error,
Error using surf (line 71)
Data dimensions must agree.
Tried transposing but that isn't working also. Please help.
My file is also attached.
T = readtable('https://in.mathworks.com/matlabcentral/answers/uploaded_files/886870/SA.xlsx') ;
z = table2array(T) ;
surf(z)
sameer kumar
2023-2-7
How to restrict boundary?
类别
在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息
2019-6-12
2023-2-7
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
