plot date from excel file
2 次查看(过去 30 天)
显示 更早的评论
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 个评论
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.
回答(2 个)
Thomas
2012-7-26
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
5 个评论
Thomas
2012-7-26
so what is your 'x'? Can you show an example of 'x' as it is imported in matlab. also what is the output of
whos x
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!