i need to convert data from hourly data to daily data and plot these data

i have hourly data in an excel sheet for a year and these data per hour but i need to plot it per day, how to do this please

these data until 8/25/2020

Answer 1

[Peter O]

1. Import using a timetable. https://www.mathworks.com/help/matlab/timetables.html
2. Decide how you want to decimate the data in column C. Does it make sense to take the average of the day? Or to only use the data at 8:00 am from each day? https://www.mathworks.com/help/matlab/matlab_prog/resample-and-aggregate-data-in-timetable.html
3. Use either plot(mytimetable.MyTimes, mytimetable.MyVariable), or stackedplot(mytimetable) to get the plot.