[R] I need help integrating ggplot2 into Excel

[Greg Snow]

I expect that this is the same as FAQ 7.22, though the FAQ should probably be updated to include ggplot as well as lattice/trellis.

Basically you need to "print" the graph (in some modes it is automatically printed, so you see it, in other modes it is not autoprinted, so you see nothing), just wrap the calls in print() commands.

-- 
Gregory (Greg) L. Snow Ph.D.
Statistical Data Center
Intermountain Healthcare
greg.snow at imail.org
(801) 408-8111
 
 

> -----Original Message-----
> From: r-help-bounces at r-project.org 
> [mailto:r-help-bounces at r-project.org] On Behalf Of Jannik Vindeloev
> Sent: Thursday, March 20, 2008 8:16 AM
> To: r-help at 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.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 mode:
> 
> Call RInterface.RRun("library(ggplot2)")
> ...
> Call
> RInterface.RRun("qplot(x=Hours,y=pH,data=ds,facets=Sample~.,ge
> om=""line"",group=Cell)")
> 
> With no output ...
> 
> I have tried the following in Worksheet function mode:
> 
> if Range(H40:I42) contains:
> "
> (Embedded image moved to file: pic10654.jpg) "
> and Range(H48) contains:
> 
> "qplot"
> 
> The following call:
> 
> =Rcalla(H48;makeargs(H40:I42))
> 
> Gives me no output
> 
> Scratchpad mode
> 
> However, right clicking a cell containing:
> qplot(x=Hours,y=pH,data=ds,facets=Sample~.,geom=""line"",group=Cell)
> and then selecting "Run R" works like a dream!
> 
> I would like to develop an excel based GUI for R-data 
> treatment and plotting, and I would like to use ggplot2 as my 
> plotting engine.
> 
> What am I doing wrong?
> 
> Thank you for your help
> 
> Jannik Vindeløv, Ph.D.
> Project Manager
> Dairy Culture Development
> Innovation
> 
> P.O. Box 64
> Arpajon
> Cedex
> F-91292
> France
> 
> Phone: +33 (0)1 6988 3636
> Direct Phone: +33 (0)1 6988 3629
>