Thanks John for your reply. I did include the data if you scroll down to the end of my original email.
Can someone help me on this? Thanks ----- Original Message ----- From: John Kane <jrkrid...@inbox.com> To: David Lyon <david_ly...@yahoo.com>; r-help <r-help@r-project.org> Cc: Sent: Tuesday, May 14, 2013 4:11 PM Subject: RE: [R] Help me please: gplot, facets_wrap and ordering of x axis dates Thank you for supplying the code. It would be easier to help you if we also had some data to work with. ?dput https://github.com/hadley/devtools/wiki/Reproducibility I think reorder() is likely to do the trick but I don't have enough time to mock up some data and check at the moment. Have a look at http://stackoverflow.com/questions/3744178/ggplot2-sorting-a-plot Good luck. John Kane Kingston ON Canada > -----Original Message----- > From: david_ly...@yahoo.com > Sent: Tue, 14 May 2013 12:59:07 -0700 (PDT) > To: r-help@r-project.org > Subject: [R] Help me please: gplot, facets_wrap and ordering of x axis > dates > > I have a text file of data as below and doing a ggplot line plot of all > the ids as separate mini line plots which works with the following code. > > Problem how do I order the dates for each id plot on the x axis so that > the dates are going from oldest to most recent???? > > > Thanks in advance > > Dave > > > > > > CODE: > > a<-read.table("DATA",header=TRUE); > b<-a[order(as.Date(a$date, format="%m/%d/%Y")),] > > ggplot(data=b) + geom_line(aes(x=date, y=value, group=id, colour= > factor(id))) + facet_wrap(~id, scales = "free") > > > > > > > DATA: > > > id date value > 001 8/16/10 <0.16 > 001 10/25/10 <0.16 > 001 11/8/10 0.42 > 001 11/22/10 0.81 > 001 12/6/10 <0.16 > 002 8/18/10 2.93 > 002 10/25/10 2.4 > 002 11/8/10 1.36 > 002 11/22/10 1.22 > 004 8/20/10 0.77 > 004 10/25/10 0.85 > 004 11/8/10 1.22 > 004 11/22/10 0.21 > 004 12/6/10 1.81 > 004 10/26/11 0.54 > 005 6/4/09 1.33 > 005 6/18/10 1.32 > 005 8/25/10 2.5 > 005 9/15/10 1.3 > 005 10/25/10 1.1 > 005 11/8/10 0.66 > 005 11/22/10 0.84 > 005 12/6/10 7.42 > 005 11/4/11 1.21 > 006 9/23/10 0.97 > 006 10/25/10 2.25 > 006 11/8/10 0.51 > 006 11/22/10 0.53 > 006 12/6/10 0.41 > 008 8/25/10 3.14 > 008 10/25/10 3.58 > 008 11/8/10 2.41 > 008 12/6/10 2.08 > 008 6/11/12 3.2 > 009 10/6/10 0.24 > 009 11/22/10 0.34 > 009 2/2/11 0.58 > 009 2/16/11 0.54 > 009 3/2/11 0.25 > 009 3/16/11 0.39 > 010 9/14/10 0.28 > 010 2/2/11 0.19 > 010 2/16/11 0.42 > 010 3/2/11 0.39 > 010 3/16/11 0.26 > 011 8/20/10 <0.16 > 011 2/2/11 <0.16 > 011 2/16/11 <0.16 > 011 3/2/11 <0.16 > 011 3/16/11 1.76 > 011 10/26/11 <0.16 > 012 12/14/10 0.48 > 012 2/2/11 1.2 > 012 2/16/11 0.44 > 012 3/2/11 0.32 > 012 3/16/11 0.34 > 013 11/13/09 0.73 > 013 8/19/10 3.32 > 013 2/2/11 13.7 > 014 2/6/13 1.35 > 014 4/24/13 0.85 > 014 8/18/10 0.66 > 014 10/5/10 0.68 > 014 10/27/10 0.53 > 014 2/2/11 0.54 > 014 2/16/11 0.49 > 014 3/2/11 0.31 > 014 3/16/11 0.4 > 014 6/29/11 0.53 > 014 8/15/11 0.55 > 014 8/15/12 0.94 > 014 10/31/12 0.74 > 015 12/10/10 0.4 > 015 2/2/11 0.44 > 015 3/2/11 0.38 > 015 3/16/11 0.43 > 016 12/17/10 0.18 > 016 1/25/11 <0.16 > 016 2/2/11 0.53 > 016 2/2/11 0.54 > 016 2/16/11 0.46 > 016 3/2/11 0.29 > 016 3/16/11 0.2 > 016 3/20/12 0.18 > 016 3/26/12 0.23 > 016 3/30/12 0.52 > 016 4/2/12 0.33 > 016 4/23/12 0.3 > 017 11/17/11 3.35 > 017 12/9/11 2.56 > 018 2/25/13 18.1 > 018 3/11/13 14.9 > 018 3/25/13 11.1 > 018 4/10/13 8.47 > 018 4/22/13 15.9 > > > ______________________________________________ > R-help@r-project.org mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide > http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code. ____________________________________________________________ FREE 3D EARTH SCREENSAVER - Watch the Earth right on your desktop! Check it out at http://www.inbox.com/earth ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
