Surface plot from excel data

Hi there,

Could anyone please help me with plotting 3d surface graph of the attached excel data.

Answer 1

[Ameer Hamza]

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

[Sairaj Ghate]

Thank you very much.... really apprreciate it.

[Ameer Hamza]

I am glad to be of help!!!