plot date from excel file
2 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
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 Commenti
Sumit Tandon
il 26 Lug 2012
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.
Risposte (2)
Thomas
il 26 Lug 2012
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 Commenti
Thomas
il 26 Lug 2012
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
Vedere anche
Categorie
Scopri di più su Spreadsheets in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!