How to plot a 3d graph with z axis, not the same length as x,y from, the data is imported from an excel sheet ?
1 回表示 (過去 30 日間)
古いコメントを表示
I have data from an experiment as attached, how can I import the data from the excel sheet and then build a surface 3-d graph?
0 件のコメント
回答 (1 件)
Dyuman Joshi
2023 年 3 月 28 日
編集済み: Dyuman Joshi
2023 年 3 月 28 日
out=readmatrix('Test1.xlsx')
%Extracting x, y and z data
x = out(1,2:end);
y = out(3:end,1);
Z = out(3:end,2:end);
%Create a mesh
[X,Y]=meshgrid(x,y);
%Draw a surface graph
surf(X,Y,Z)
%You can also extract data via readmatrix() and the range of data from excel
x0 = readmatrix('Test1.xlsx','Range','C2:P2')
%similarly y0 = readmatrix('Test1.xlsx','Range','C4:C21')
%z0 = readmatrix('Test1.xlsx','Range','C4:P21')
0 件のコメント
参考
カテゴリ
Help Center および File Exchange で Bar Plots についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!