Surface plot from excel data
显示 更早的评论
Hi there,
Could anyone please help me with plotting 3d surface graph of the attached excel data.
回答（1 个）
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
类别
在 帮助中心 和 File Exchange 中查找有关 Surface and Mesh Plots 的更多信息
2020-11-13
2020-11-13
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
