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
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
On Wed, Jan 14, 2009 at 8:10 AM, Gerhard Hellriegel <
> 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.
> 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
> >SAS, ie not an image file.