How to repeatedly remove the connecting lines between the first an the last points on a surf plot.

Its a plot with dates on the x-axis, time on the y-axis and power usage on the z-axis. So i got the mentioned issue for every day in the year and cannot fix it manually. As you can see im an absolute beginner in Matlab.... Thanks for help.

a=nan(1,208)';
date=[column1;a];
time=[column2;a];
usage=[column3*3.5*77.826;a];
datere=reshape(date,188,[]);
usagere=reshape(usage,188,[]);
timere=reshape(time,188,[]);
surf(datere,timere,usagere)

[jonas]

Could you upload the data?

[Stephen23]

Benedikt Wessel's "Answer" moved here:

Yes of course, i only need the first sheet.

Answer 1

[jonas]

Here is your lastkurven!

TT=readtable('Lastkurven.xlsx');
Date=TT.Date;
Time=duration(days(TT.Time),'format','hh:mm');
x=unique(Date)
y=unique(Time)
z=reshape(TT{:,3},length(y),length(x));
surf(x,y,z)

[Benedikt Wessel]

Thank you so much!!! You saved me...

[jonas]

No problem!

The key is to put the z-data in a rectangular grid. Note that this solution (with unique) worked because the data set was very well structured to begin with, primarily referring to the exact 15-minute intervals. Normally, when the recordings are not exact, you first have to interpolate.

[Benedikt Wessel]

A very helpful Information, I think I have to use this in my next tasks. Thanks mate

[Benedikt Wessel]

I got a new issue, regarding the second page on the excel sheet. Why isn't the code working there? I think its because of some missing data, should I interpolate there like you already mentioned or what should I do?