[R] Make a Excel chart by R code

[John Kane]

John Kane
Kingston ON Canada


> -----Original Message-----
> From: miaojpm at gmail.com
> Sent: Wed, 15 Apr 2015 11:54:13 +0800
> To: r-help at r-project.org
> Subject: [R] Make a Excel chart by R code
> 
> Hi,
> 
>    I understand that there're many great graphic packages in R (e.g.,
> ggplot2) . Nevertheless, my office uses Excel extensively. 

Oh dear what a pity Cryer, Jonathan D. “Problems with Using Microsoft Excel for Statistics.” In Joint Statistical Meetings, 2001. http://www.amstat.org/sections/srms/proceedings/y2001/proceed/00470.pdf.


Unless you need to have the graphs updating all the time in Calc would it not be just as handy to produce the charts/graphs in R and just import them into your final product.

A little bit more work but far superiour graphics and easier maintenance of the graphs.  It is much easier to change one line (or one word of code) than to start frenzied clicking all over again.

____________________________________________________________
Can't remember your password? Do you need a strong and secure password?
Use Password manager! It stores your passwords & protects your account.