Excel data import 3D Plot

4 次查看（过去 30 天）
Kunter Özbay
Kunter Özbay 2020-12-31
评论： Star Strider 2021-1-2
Hello everybody,
i have this excel below and i would like to plot a 3D graph (surface or sth like that) for the two axes (1-30 and 95 to 5 with 5 steps as axes). I have imported the data as cell array and tried the command below but i get an error that the dimensions not match. Then i delete the first row and columb from x and y to let them have the same dimension, still not working. Can anybody help me?
x = num(:,1) ;
y = num(1,:) ;
Z = num(2:end,2:end) ;
surfl(x,y,Z)

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

采纳的回答

Star Strider
Star Strider 2020-12-31
Try this:
num = rand(5,7); % Create Matrix (To Test Code)
x = (1:size(num,1)).'; % Column Vector
y = (1:size(num,2)); % Row Vector
Z = num;
figure
surfl(x, y, Z.') % Transpose ‘Z’ And It Works!
.
  2 个评论
Kunter Özbay
Kunter Özbay 2021-1-2
I just realized with your answer, that i needed to manipulate the data a bit better to get the desired output. Thanks for leading the way :)
Star Strider
Star Strider 2021-1-2
As always, my pleasure!

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by