topic Re: Graphics into Excel? in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/Graphics-into-Excel/m-p/114818#M31753 <HTML><HEAD></HEAD><BODY><P>ExcelXP doesn't do native Excel files anyways. If you're okay with that, you can also try the MS_OFFICE or HTML ODS Tagsets.</P></BODY></HTML> Thu, 17 Oct 2013 19:17:22 GMT Reeza 2013-10-17T19:17:22Z Graphics into Excel? https://communities.sas.com/t5/SAS-Procedures/Graphics-into-Excel/m-p/114816#M31751 <HTML><HEAD></HEAD><BODY><P><BR />I am trying to create a spreadsheet with graphics from SAS graph and Several tables.&nbsp; I understand that the ExcelXP tagset does not support importing graphics.&nbsp; Is ther another way to create both tables and graphics in the same Excel file?</P></BODY></HTML> Thu, 17 Oct 2013 16:20:41 GMT https://communities.sas.com/t5/SAS-Procedures/Graphics-into-Excel/m-p/114816#M31751 RickZ 2013-10-17T16:20:41Z Re: Graphics into Excel? https://communities.sas.com/t5/SAS-Procedures/Graphics-into-Excel/m-p/114817#M31752 <HTML><HEAD></HEAD><BODY><P>You can write an Excel Macro (in VBA or through the recorder) that does the graphic import for you which you could call from within your SAS program.</P><P></P><P>I dont have a specific example of this to provide, but I would create the sas graphics files, create the macro off the created graphic files, then go back and add the macro call to your sas program.</P><P></P><P>Alternatively would be to output the data to the excel file and use Excel to do the graphing. This wont help if the data structure changes a lot though.</P><P></P><P>EJ</P></BODY></HTML> Thu, 17 Oct 2013 18:31:56 GMT https://communities.sas.com/t5/SAS-Procedures/Graphics-into-Excel/m-p/114817#M31752 esjackso 2013-10-17T18:31:56Z Re: Graphics into Excel? https://communities.sas.com/t5/SAS-Procedures/Graphics-into-Excel/m-p/114818#M31753 <HTML><HEAD></HEAD><BODY><P>ExcelXP doesn't do native Excel files anyways. If you're okay with that, you can also try the MS_OFFICE or HTML ODS Tagsets.</P></BODY></HTML> Thu, 17 Oct 2013 19:17:22 GMT https://communities.sas.com/t5/SAS-Procedures/Graphics-into-Excel/m-p/114818#M31753 Reeza 2013-10-17T19:17:22Z