plot date from excel file

Question

Samer Husam 2012-7-26

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/44590-plot-date-from-excel-file

hi all, I am trying to plot power vs time in my program, these values are taking from excel file, but I am having different values for the time compare with values in excel, the time format is (HH:MM)and my code is:

 [num,T,vT] = xlsread(excle.xls,'Sheet1');      % reading excel
    x = num(:,1);                               % Time column
    y = num(:,4);                               % power column  
    plot(handles.axes,x,y);

how can I over come this issue ??? please help and advice...

3 个评论
显示 1更早的评论隐藏 1更早的评论

Sumit Tandon 2012-7-26

Not sure if I understand the question correctly. Are you having issues with the FORMAT of date in Excel vs MATLAB? You could use functions like DATENUM or DATEVEC to change the format and then plot as per your requirements.

Samer Husam 2012-7-26

conrad: the time value is read from MATLAB it something like: 12:00, 12:15, 12:30 and so on. when I use the code that I post above, I get numeric values like 0.5, 0.51... so how can I display the time values from the excel ??

LukeS: I have tried to use the datenum but what I couldn't get it correctly, can you please show me how to use it ?

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Thomas 2012-7-26

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/44590-plot-date-from-excel-file#answer_54671

在 MATLAB Online 中打开

Something like this

x={'12:00','12:15','12:30','12:45'}; %time
y=[0.5 0.8 0.3 0.6]                % values
time_out=datenum(x,'HH:MM');  %convert time to datenum
plot(time_out,y)              
datetick('x','HH:MM')         % show datetick on xaxis