time series plot

I am trying to plot tidal level over time, but am struggling to get the date and time accurately along the X-axis. The time data is currently in a date vector format of 6 columns [dd mm yy hh mm ss]. What is the best way to convert this data into a format which can be plotted on the x-axis against water level? The matrix lengths are the same. Cheers!

Answer 1

[Wayne King]

Did you use datenum and datetick?

         t = (1900:10:1990)'; % Time interval
         p = [75.995 91.972 105.711 123.203 131.669 ...
             150.697 179.323 203.212 226.505 249.633]';  % Population
         plot(datenum(t,1,1),p) % Convert years to date numbers and plot
         datetick('x','yyyy') % Replace x-axis ticks with 4 digit year labels.

Answer 2

[Jamie]

I have tried but cant manage to work it out. I will try again now

Answer 3

[Jamie]

I've tried using datenum for the vector array to convert into a serial date number using DateNumberArray = datenum(DateVectorArray). It comes up with an error message when I try to input the matrix name in a string. It outputs a serial number for individual inputs, but not for the whole matrix. Can i use the datenum function for the entire matrix? Its made up of 6 columns (yy mm dd hh mm ss) and 43000 rows. Thanks for your help

[Win co]

post your data file and we will figure out

[Jamie]

where/how do i post the file? sorry, i am new to this!