CODEWITHSUNDEEP
matlab
SHENGNAN LI
SHENGNAN LI

Reputation: 73

Matlab how to remove the weekend from the chart

I want to plot a line chart that the x-axis is datetime. But there is a weekend gap in the chart. I wonder how can I remove the gaps of the weekends.

enter image description here

figure
plot(data.DateTime(1:833),data.diff(1:833),'b');
hold on
plot(data.DateTime(834:970),data.diff(834:970),'r');
hold on
plot(data.DateTime(971:1546),data.diff(971:1546),'b');
hold off

Upvotes: 0

Views: 282

Answers (1)

scotty3785
scotty3785

Reputation: 7006

You can use weekday to filter your date to only include values for days of the week that aren't 6 or 7 (Saturday or Sunday)

days = datetime(2021,5,0:31);
days_weekdays_only = days(and(weekday(days)~=1,weekday(days)~=7));

This will filter the days data to only contain dates that are Mon-Fri.

Then plot this filtered data.

Edit: You can plot the values against an index of the filtered data and then change the x-axis labels to match the datetime string. This way it will skip the weekends but the x-axis will still show the date time.

days = datetime(2021,5,0:31);
weekdays = days(and(weekday(days)~=1,weekday(days)~=7));
data = randi(5,length(days),1);
data_weekdays = data(and(weekday(days)~=1,weekday(days)~=7));
idx = 1:length(weekdays);
plot(idx,data_weekdays)
set(gca,'XTickLabel',datestr(weekdays));

Upvotes: 1

Related Questions