how to plot date and time on x axis and data on yaxis from excel sheet using MATLAB

help plot IST on Xaxis and Z on Yaxis?

[madhan ravi]

datetime() ?

Answer 1

[KSSV]

Read about readtable

T = readtable('BookP.xlsx') ;
plot(T.(1),T.(2))   % Pick the index you want T.(i)
% plot whole data
T = readtable('BookP.xlsx') ;
plot(T.(1),T{:,2:end}) ;
str = properties(T) ;
legend(str)

[meenu v]

sir, im using matlab 2014 version ...readtable is not available in the version...

[KSSV]

[num,txt,raw] = xlsread('BookP.xlsx') ;
thedates = datetime(raw(2:end,1)) ;
str = txt(1,2:end) ;
plot(thedates,num) 
legend(str)

[Orlando Ramirez-Valle]

Thank you, this was very useful to me