Hi, I understand that there're many great graphic packages in R (e.g., ggplot2) . Nevertheless, my office uses Excel extensively. Is there any package in R that produces Excel graphs by R codes? Thanks!
Make a Excel chart by R code
4 messages · John, Jim Lemon, David Stevens +1 more
Hi jpm miao, What sort of "Excel" graphs do you want to produce? There are a few varieties, you know. Jim
On Wed, Apr 15, 2015 at 1:54 PM, jpm miao <miaojpm at gmail.com> wrote:
Hi,
I understand that there're many great graphic packages in R (e.g.,
ggplot2) . Nevertheless, my office uses Excel extensively. Is there any
package in R that produces Excel graphs by R codes? Thanks!
[[alternative HTML version deleted]]
______________________________________________ R-help at 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.
By this, do you mean you want to use R to send data to Excel and have Excel create the graph without your intervention, or to use R to create a graph that looks like one of those that Excel produces? David
On 4/14/2015 9:54 PM, jpm miao wrote:
Hi,
I understand that there're many great graphic packages in R (e.g.,
ggplot2) . Nevertheless, my office uses Excel extensively. Is there any
package in R that produces Excel graphs by R codes? Thanks!
[[alternative HTML version deleted]]
______________________________________________ R-help at 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.
David K Stevens, P.E., Ph.D. Professor and Head, Environmental Engineering Civil and Environmental Engineering Utah Water Research Laboratory 8200 Old Main Hill Logan, UT 84322-8200 435 797 3229 - voice 435 797 1363 - fax david.stevens at usu.edu
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.