similar to: export graph to Word/Excel

Hi, I have a data set look like this: ================================= Fruit Quty apple 20 banana 10 orange 17 apple 30 apple 15 orange 26 banana 15 .........and so on .......... ================================= The level of fruit is 30, that is, there are 30 different fruits. I'd like to compute some simple statistics for each different fruit and get output like this:

For the first error message: > win.metafile(file = "//.../plot1.wmf", + width = 8.5, height = 6.25) > lset( list( background = list(col = "white"))) Error in get(x, envir, mode, inherits) : variable "win.metafile://.../plot1.wmf" was not found > traceback() 4: get(device) 3: trellis.device(device = .Device, new = FALSE) 2: trellis.par.get(item) 1:

Further to my earlier question. Thank you to: John Maindonald, Ramon Diaz-Uriarte, Brian Ripley, Alvaro Novo, Simon Bond and David Scott for your helpful replies. I have looked at the problem in some more detail. I am using Rgui.exe Version 0.64.2 (July 3, 1999) running under Windows NT To demonstrate the problem, I run the program: > win.graph(width=5, height=3) > data(women) >

Hola, ¿qué tal? Me han pedido que genere unos gráficos para insertarlos en un docuemento de Word. Yo suelo generar gráficas en formato PNG, pero me han dicho que "quedan mal". Y yo apenas sé nada de Word. ¿Cuál sería el formato gráfico más adecuado en este caso? Un saludo y muchas gracias, Carlos J. Gil Bellosta http://www.datanalytics.com

Hi, I am revising a paper that I am a co-author of. The figures are plots generated from R but at the moment I do not have the R code that generates them. As this is time critical I would like to slightly abuse the list by asking whether anyone knows how to extract from MS Word into a stand-alone graphics file a plot that was pasted into Word from R (probably as a Windows Metafile, but possibly

hi, all. I use R on a unix (linux) box and am quite happy with it. However, sometimes I need to create a graph that needs to be used with Microsoft Word or Powerpoint (ug). I can create a png or jpeg format picture, but the text look pretty crummy because jpeg is bitmapped. I can also create a PS/EPS version (my preference), but then it doesn't display properly in word or powerpoint (but it

Hi, I'd like to pass a string to a function as the value of the argument. Here is my code. However, it doesn't work. Please help me with this. Thanks, Yu-Ling Wu ----------------------------------------------------- library(RODBC) odbcConnect("console") -> myConnect fun1 <- function(dd1) { h3 <- sqlQuery(myConnect, "select * from console where byday =

My apriori apologies if this is felt to be the wrong list for this issue - although it starts with R, it's a combination of programs that creates the problem. Currently we are using windows metafile format for in-text tables for reports created in Word. However, we've discovered some artifactual lines being created in our final output once the Word document is changed to PDF. The process

Hi everyone, I am trying to make some publication-quality plots for use in Microsoft Word, but I am having trouble creating high-quality plots that are supported by Microsoft Word. If I use the R plot function to create the figure, the lines are jagged, and the picture is not of high quality (same with JPEG(), TIFF(), and PNG() functions). I have tried using the Cairo package, but it distorts

Hi, I use R under Windows NT. I download "RODBC.zip" and unzip it to "e:/R/rm1011/lib/" in order to connect to MySQL. And then I add an MySQL ODBC data source in the Control Panel. When I type "library()" under R, I can see "RODBC" is one of the packages. However, when I type "library (RODBC)", I got an error message like this: The procedure

I would like to ensure that all the text in my plot is in the arial font, like in excel and word. I have been saving my graphics to a file using the png() function, and have tried the postscript() function. In the documentation I have not been able to find a way of changing the family argument to an arial font. Does it exist? How would I go about creating a png or ps graphic using Arial?

Colleagues ---------------------------------- On 6 Mar 01,, Yu-Ling Wu wrote (re: [R] export graph to Word/Excel): > I have a set of script like this: > > ---------------------- > summary(data) > plot(time, users, type="o", xlab ="Time", ylab="Number > of Users") > ---------------------- > > I type "rterm --slave < script.r >

R Experts I'm currently using an S+ script of the following format and would like to convert it to R. The script opens a graphsheet with an associated name, plots something (in this case a boxplot) and then exports the contents of the graphsheet of the assigned name to an EMF file. I've been looking for something in R that would work the same way but to no avail. Could someone

Hi there, I need to save a series of lattice plots as a PDF, this is my code so far: windows(height=8,width=6) plot.new() library('grid') lattice.options(layout.heights=list(top.padding=list(x=0.15, units="inches"))) print(plot1, split=c(1,1,2,3), more=TRUE) print(plot2, split=c(1,2,2,3), more=TRUE) print(plot3, split=c(1,3,2,3), more=TRUE) print(plot4, split=c(2,1,2,3),

Dear R devel, being constrained to a windows environment at work and having colleagues being accustomed to the Microsoft Office Suite, I was looking for a way to have the RweaveLatex driver for Sweave automatically generating 'win.metafile's in addition to the pdf graphics. Without this functionalilty, the generation of emf-graphics is quite laborious, I think: <<>>= plotit

I have an R file R_test.R saved in C:\R_test folder. The R_test.R looks like this: setwd("C:/R_test") rnorm(100) write(rnorm(100),"data.txt") q(save="no", runLast = F) Next I would like use an Excel VBA/macro Shell() function to call R and execute R_test.R file. The syntax is *Shell(pathname*[*,windowstyle*]*)* I wrote an Excel macro RunRcode like this: Sub

Dear all, i use the following package/syntax to export data to excel: library(xlsReadWrite) write.xls( exportdata,pfad,colNames = TRUE,sheet = 1,from = 1,rowNames = FALSE ) Everything is fine, but the format of the export is not the best. For example, I every time have to adjust the column width. Furthermore there is no possibility to highlight some cell or make them colourful. I create a lot

Hello, The journal I am publishing in requires MS Word files. What is my best option for getting a high quality image of a graph done in R into Word? JPEG? Postscript? Thanks. -- View this message in context: http://www.nabble.com/R-graph-into-MS-Word%3A-which-format-to-use--tp23133745p23133745.html Sent from the R help mailing list archive at Nabble.com.

Greetings List, I am conducting some large simulations using R. As a result, I get many plots but I'm having some trouble with including some of them in a Microsoft Word document. Can any one tell me the easiest method of having copies of the R-graphs in the Word documents? Best regards Mahmoud [[alternative HTML version deleted]]

Dear all, I'm stuck with the following problem: I generate graphs using both the grid system (with lattice) and the base system. I'd like to be able to identify these graphs later on with a bit of identifying text (e.g. a date and some comments). Adding text to these graphs cannot be done using a common system if you want to save them as emf files. I now use: mtext("labelling