Surface plot from excel data

8 次查看(过去 30 天)
Sairaj Ghate
Sairaj Ghate 2020-11-13
评论: Ameer Hamza 2020-11-13
Hi there,
Could anyone please help me with plotting 3d surface graph of the attached excel data.

回答(1 个)

Ameer Hamza
Ameer Hamza 2020-11-13
编辑:Ameer Hamza 2020-11-13
This is one way
data = readtable('load.xlsx');
month_names = data.Properties.VariableNames(2:end);
x = 1:numel(month_names);
y = data.Hour;
z = data{:, 2:end};
ax = axes();
[X, Y] = meshgrid(x, y);
surf(X, Y, z)
ax.XTick = x;
ax.XTickLabel = month_names;
ax.XTickLabelRotation = -45;
In case you need to plot lines
data = readtable('load.xlsx');
month_names = data.Properties.VariableNames(2:end);
x = 1:numel(month_names);
y = data.Hour;
z = data{:, 2:end};
ax = axes();
[X, Y] = meshgrid(x, y);
plot3(X, Y, z)
ax.XTick = x;
ax.XTickLabel = month_names;
ax.XTickLabelRotation = -45;
grid on
  2 个评论
Sairaj Ghate
Sairaj Ghate 2020-11-13
Thank you very much.... really apprreciate it.
Ameer Hamza
Ameer Hamza 2020-11-13
I am glad to be of help!!!

请先登录,再进行评论。

类别

Help CenterFile Exchange 中查找有关 Surface and Mesh Plots 的更多信息

产品


版本

R2020a

Community Treasure Hunt

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

Start Hunting!

Translated by