search

sdllc / Basic-Excel-R-Toolkit

http://bert-toolkit.com
207 stars 40 forks source link

Setting graphics parameters #90

Closed FrankAcito closed 6 years ago

FrankAcito commented 6 years ago

Is there any way to increase the size of the graphics image returned to Excel? I tried to set the size using par(din=c(10,10)), but this does not work. Is there a parameter in BERT.graphics.devices() that can be set? Thanks.

duncanwerner commented 6 years ago

width and height, or just resize with the mouse. See ?BERT.graphics.device.

FrankAcito commented 6 years ago

??Hello,

Thanks for the quick response. I found that I could instead create a pdf file from the R code and size that as needed. The problem is that BERT graphics returns an image of fixed size. It cannot be effectively resized once in Excel. I tried resetting several different parameters for graphics in the BERT R console, but was unable to change the dimensions from about 5.7 by 5.7.

In any case, thanks so much for developing this tool. I will be using it in my classes in the next few months. Also, I wonder if it would be useful to create a place where users could share their examples using BERT. I have developed some VBA to interface with R regression, logistic regression, and naive Bayes. I working on additional tools and would be willing to share these.

Frank Acito

Professor

Kelley School of Business

Indiana University

Bloomington, Indiana

From: duncanwerner notifications@github.com Sent: Saturday, December 2, 2017 4:11 PM To: sdllc/Basic-Excel-R-Toolkit Cc: Acito, Franklin; Author Subject: Re: [sdllc/Basic-Excel-R-Toolkit] Setting graphics parameters (#90)

width and height, or just resize with the mouse. See ?BERT.graphics.device.

- You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://github.com/sdllc/Basic-Excel-R-Toolkit/issues/90#issuecomment-348720412, or mute the threadhttps://github.com/notifications/unsubscribe-auth/AUMnJsxVC0dFZiSffAzkTi0PNxaF8xRWks5s8bzxgaJpZM4QzXdV.

duncanwerner commented 6 years ago

If you resize the graph in Excel, you need to redraw it. There's no way for us to get notified of the resize (short of polling, which we won't do). We use raster graphics because there's no support for any vector format in Excel. PDFs will always print better than anything we can draw in Excel for that reason.

Having a place for contributed content is a good idea, we'll set something up. But this (github issues) is not a good platform for communication, send me an email directly if you would like to discuss.