Plot data with date and time

4 views (last 30 days)
Hüseyin Uzun
Hüseyin Uzun on 10 Jun 2021
Answered: KSSV on 10 Jun 2021
I have an excel file which is created automatically and data is added every 10 minutes. I want to read and plot the days once a day, so I take the last 144 data points. When I plot x and y, the error message "Error using plot. Not enough input arguments."
I know that I have to convert my x vector, which contains the time data, somehow. I have looked at the forums and tried different approaches, but it has not worked so far.
x1=datenum(x,'HH:MM:SS');
This one didn't work especially since I don't know how to add the date next to the time.
so far i have only managed to extract the x and y values, which i need for now, from the excel file:
table=readtable('Datalogger.xlsx');
x=table.DatumUndUhrzeit;
x=x(end-144:end);
y=table.Temp_R_210__C;
y=y(end-144:end);

Accepted Answer

KSSV
KSSV on 10 Jun 2021
thedates = datetime(datestr((x)));
y = str2double(y) ;
plot(thedates,y)

More Answers (0)

Categories

Find more on Graphics Object Identification in Help Center and File Exchange

Products


Release

R2019b

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!