hello , I am very new to R, till now I was working with lineplots reading
their data from .xls files. All was working as expected,
now I want to label the data-values with "date"-values on the x line. But I
have absolute no clue how to read and interprete these values as date-values
not just only integer, I was testing and searching solutions with the
convert function. I hop I just need only one or two modifications in my
code, and all is working. Any Ideas?
this is my testcode, and the example values in the .xls, (with integer
values, all is working correctly.)
textcode.r
require(XLConnect)
wb = loadWorkbook("C:/xlsfile.xls")
impdata = readWorksheet(wb, sheet = "Data", header = TRUE)
datec(c) <- as.Date(impdata$date, "%d.%m.%y")
plot(datec,impdata$amount, main="amount year to date",type="n", ylab="Eur",
xlab="year to date",ylim=c(1,6000))
lines(datec,impdata$amountmount, col = "steelblue")
xls-file
date amount
30.01.2015 1000
30.02.2015 2000
15.03.2015 2800
THANX in advance for your help.
--
View this message in context:
http://r.789695.n4.nabble.com/values-in-date-format-from-xls-as-label-on-x-line-tp4711949.html
Sent from the R help mailing list archive at Nabble.com.
______________________________________________
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.
