Re: [R] I need help integrating ggplot2 into Excel

2008-03-20 Thread Felipe Carrillo
Create an R script,name it "Myggplot2" and place it on your desktop.In excel open the vb editor and write this code: Sub Myggplot2() 'start R Call rinterface.StartRServer 'Put the dataframe into R,assuming that your 'data is in sheet1 cells A1:D1 Call rinterface.PutDataframe("yourdataframename", R

Re: [R] I need help integrating ggplot2 into Excel

2008-03-20 Thread Greg Snow
nt: Thursday, March 20, 2008 8:16 AM > To: r-help@r-project.org > Subject: [R] I need help integrating ggplot2 into Excel > > > Dear all > > I use ggplot2 extensively for my plotting routines and rexcel > to have the best of two worlds. (RExcel v 1.75 and R (D)Com v. 2.

[R] I need help integrating ggplot2 into Excel

2008-03-20 Thread Jannik Vindeloev
Dear all I use ggplot2 extensively for my plotting routines and rexcel to have the best of two worlds. (RExcel v 1.75 and R (D)Com v. 2.5) I can run my ggplot functions, such as qplot(...), in scratchpad mode, but not in Macro nor Worksheet functions mode. I have tried the following in Macro m