How can I get MATLAB to plot a date on the x-axis?

12 views (last 30 days)
I have a dataset with column1 = date and column2 = data. The problem is that my date is in yyyymmdd format. How can I get MATLAB to plot the date correctly in the x-axis?
Thank you in advance! :)

Accepted Answer

dpb
dpb on 21 Oct 2013
First convert the text string date format to Matlab serial dates --
doc datenum
Then plot with that value as the x-axis value and format the dates as desired via
doc datetick
dn=datenum(data(:,1),'yyyymmdd');
plot(dn,data(:,2))
datetick('x','keepticks','keeplimits')
Salt to suit...
  2 Comments
William
William on 28 Jan 2020
Thank you! This had been driving me nuts, but now works perfectly.
dpb
dpb on 28 Jan 2020
This answer is now out of date...use the new(ish) datetime class instead of datenum

Sign in to comment.

More Answers (2)

Sandy
Sandy on 21 Oct 2013
Hi dpb. I tried it this way, but for some reason it's plotting all my data as one date.
  2 Comments
Sandy
Sandy on 21 Oct 2013
Nevermind, I got it. I had to convert my number to strings first. Thank you! :)
dpb
dpb on 21 Oct 2013
Oh, didn't think about the first column being integer, granted...just for the record, alternatively, you could separate out the separate fields and use the
datenum(y,m,d,h,mn,s)
form to generate the serial numbers.

Sign in to comment.


Dainty Daisy Calgas
Dainty Daisy Calgas on 3 Dec 2017
Hello, how could I plot a quarterly data with column1, written as Q1:1991 up to Q4:2016, then my column2 is my data., please I really need help, it was in the excel.
  1 Comment
dpb
dpb on 3 Dec 2017
Better form would be to create a new question, but it is at least related so I'll consider it here as "close enough"... :)
Problem first is we need to know how the date data are actually stored and imported. Since the date of the original Q, TMW has introduced the datetime class/object and improved graphics routines to be datetime aware so things are different now than then...

Sign in to comment.

Categories

Find more on Dates and Time in Help Center and File Exchange

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!