Hi Pedro, melt() is probably working. The problem is I did not finish the copy and paste. It would have been better if I had included the ggplot() command.
Try ============================================================== library(reshape2) library(ggplot2) dat1 <- structure(list(N = c("I", "II", "III", "IV", "V", "VI", "VII", "VIII", "IX", "X", "XI", "XII", "XIII", "XIV"), M = c(10L, 124L, 321L, 777L, 896L, 1706L, 635L, 1437L, 693L, 1343L, 1221L, 25L, 3L, 7L), W = c(106L, 484L, 874L, 1140L, 996L, 1250L, 433L, 654L, 333L, 624L, 611L, 15L, NA, 8L)), .Names = c("N", "M", "W"), class = "data.frame", row.names = c(NA, -14L)) dat2 <- melt(dat1) ggplot(dat2, aes(N, value, colour = variable, group = variable)) + geom_point() + geom_line() ============================================================= I feel very stupid. On Tuesday, May 22, 2018, 10:40:09 p.m. EDT, Pedro páramo <percentil...@gmail.com> wrote: Many thanks, My goal is to make a plott like attached but the Y axis starts in XIV and end at top in I. Generally for instance in excel X axis is categories but Y axis is numbers I want the contrary plotted in lines, your last help is near what I look but barplot is not needed. Hope you can help me thanks in advance. 2018-05-22 0:58 GMT+02:00 Jim Lemon <drjimle...@gmail.com>: > Hi Pedro, > In addition to the other suggestions, here's a guess at what you want > by the lines for M and W: > > ppdf<-read.table(text="N M W > I 10 106 > II 124 484 > III 321 874 > IV 777 1140 > V 896 996 > VI 1706 1250 > VII 635 433 > VIII 1437 654 > IX 693 333 > X 1343 624 > XI 1221 611 > XII 25 15 > XIII 3 NA > XIV 7 8", > header=TRUE) > barpos<-barplot(t(as.matrix(ppdf[,2:3])),horiz=TRUE, > names.arg=ppdf$N,beside=TRUE,col=c("red","blue")) > legend(1000,8,c("W","M"),fill=c("blue","red")) > lines(ppdf$W,barpos[2,],col="blue") > lines(ppdf$M,barpos[1,],col="red") > > Jim > > > On Mon, May 21, 2018 at 10:44 PM, Pedro páramo <percentil...@gmail.com> > wrote: > > Hi all, > > > > I´m trying to plot this data > > > > N M W > > I 10 106 > > II 124 484 > > III 321 874 > > IV 777 1140 > > V 896 996 > > VI 1706 1250 > > VII 635 433 > > VIII 1437 654 > > IX 693 333 > > X 1343 624 > > XI 1221 611 > > XII 25 15 > > XIII 3 > > XIV 7 8 > > So that in de Y axis will be the level (qualitative data) and in the X > axis > > will be M and W variables. So x axis will be wwith a lenght between 0 and > > 2000. > > > > I would like to plot a line with M and other with W so it will be obvious > > that above V (in the Y axis) thera are more W and below level V there are > > more M. > > > > Can you please guide me? > > > > In excel putting Y as X axis is easy but dind´nt achieve to invert rows > and > > I ´m trying to plot it in R. > > > > Many thanks in advance > > > > [[alternative HTML version deleted]] > > > > ______________________________________________ > > R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see > > 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. > [[alternative HTML version deleted]] ______________________________________________ R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see 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. [[alternative HTML version deleted]] ______________________________________________ R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see 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.