Set Graph size in ODS Excel

DME790 — Thu, 26 Apr 2018 01:23:29 GMT

Hi All,

I would like to set the size of my graphs in ODS Excel.

The current out put sizes the graphs to 9.87cm x 14.99cm (3.88inch x 5.9inch)

I would like to set the graphs to 17cm x 26cm (6.6inch x 10.2inch)

I have used both of the below to no avail.

ods graphics on / width=8in height=4in;

goptions vsize=10cm hsize=20cm

%let DateVAR =  %sysfunc(intnx(day,%sysfunc(today()),-1),yymmddn8.);
ods excel file="/test/Testa&DateVAR..XLSX";
ODS EXCEL OPTIONS (EMBEDDED_Titles="YES" sheet_Interval="NONE");
ODS Excel Options (embedded_Titles="YES") NOGTITLE NOGFOOTNOTE;
ods graphics on / width=8in  height=4in;
ods excel options(sheet_name='Overall');



Proc SGPLOT data=test;
 Series x=Date y=successful / lineattrs=(color=blue thickness=3) Legendlabel='Successful';
 Series x=Date y=Unsuccessful / lineattrs=(color=RED  thickness=3) Legendlabel='UnSuccessful';
 yaxis display=(noline noticks) grid values=(0 to 325000 by 25000) offsetmin=0 label='Count';
 Format Successful UnSuccessful comma9.;
 RUN;

Any help in resizing the graphs is appreciated.

Cheers

Dean

Re: Set Graph size in ODS Excel

JamesM1962 — Fri, 26 Apr 2019 18:59:17 GMT

I ran into this issue today. It looks like SAS writes pages to excel to fit the default destination print size. I changed the output orientation and papersize to a format that better fit my needs as follows:

options orientation=LANDSCAPE; /* LANDSCAPE/PORTRAIT */

options papersize=legal; /* LETTER is 11 X 8.5, LEGAL is 14 X 8.5 */

topic Set Graph size in ODS Excel in SAS Enterprise Guide

Set Graph size in ODS Excel

Re: Set Graph size in ODS Excel