Desktop productivity for business analysts and programmers

Set Graph size in ODS Excel

Reply
Frequent Contributor
Posts: 108

Set Graph size in ODS Excel

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

Ask a Question
Discussion stats
  • 0 replies
  • 160 views
  • 0 likes
  • 1 in conversation