LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (January 2009, week 2)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Wed, 14 Jan 2009 09:38:55 -0600
Reply-To:   Joe Matise <snoopy369@GMAIL.COM>
Sender:   "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:   Joe Matise <snoopy369@GMAIL.COM>
Subject:   Re: Excel editable graphs with SAS
In-Reply-To:   <200901141410.n0EBl99l028829@malibu.cc.uga.edu>
Content-Type:   text/plain; charset=ISO-8859-1

I agree with Gerhard; we do several projects that require this, and DDE is the easiest way.

If you cannot do DDE, then you can produce a static file with data, and then write a short VBA macro in Excel to create the graph from the data you produce. This shouldn't be difficult even if you don't know VBA, as you can just record a macro from creating the graph the first time, and then reuse that macro.

-Joe

On Wed, Jan 14, 2009 at 8:10 AM, Gerhard Hellriegel < gerhard.hellriegel@t-online.de> wrote:

> I'm not aware that it is possible to edit graphs with EXCEL!? Do you mean > that EXCEL graphs, produced from table-areas? In that case, you could > create a template with data and the attached graphs. Maybe it is possible > to create that graphs via commands, in that case that might also be > possible from SAS, but I think it is easier to create them from EXCEL. > After that you create a DDE connection for the data areas and send the new > data from SAS to EXCEL via DDE. The graphs should adapt to that new (or > changed) data. > > Other graphs (GIF, JPG, PNG, ...) are static in EXCEL. I don't think that > EXCEL has a graphic editor to manipulate GIFs or JPGs. > > Gerhard > > > > > > > > On Wed, 14 Jan 2009 10:58:55 +0100, Erwan LE DU <dotker@GMAIL.COM> wrote: > > >Hi everyone, > > > >Does anyone know whether it is possible to create editable Excel graphs > from > >SAS, ie not an image file. > > > >Thanks, > > > >Erwan >


Back to: Top of message | Previous page | Main SAS-L page