I have a vector with data (1x9324 double) and another vector (1x9324 cell) with the corresponding dates. Both vectors are from an Excel sheet using 'xlsread'. The dates are in string format and not equidistant. e.g.
'02.01.2007 08:45:00'
to
'31.12.2008 12:27:00'
'31.12.2008 15:31:00'
'31.12.2008 16:35:00'
'31.12.2008 16:35:00'
'31.12.2008 16:35:00'
There are also dates wich are exactly the same. But I do not want to interpolate or take averages. I want to plot the data on the Y axis and the dates on the X axis, just month and year are enough. I tryed
startDate = datenum('02.01.2007');
endDate = datenum('31.12.2008');
xData = linspace(startDate,endDate,9324);
plot(xData,data_vector);
datetick('x','mmm,yy','keepticks');
But I'm afreid that the dates are now equidistant. Then I tryed
ts = timeseries (data_vector, datenum(date_vector));
plot(ts);
But both vectors changed in length and values. Maybe because the timeseries tool is taking averages of the data where the dates are the same.
System:
MATLAB 7.10.0 (R2010a)
Microsoft Excel 97-2003 Worksheet (.xls)
Windows 8.1 64Bit
Thanks in advance!
