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]]
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. >[[alternative HTML version deleted]]
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.