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!