SAS graph worsksheet for a set of graphs

[SASAna]

Hi SAS users,

I have 10 graphs in first work sheet &  wanted help in displaying 10 more graphs in the second work sheet.

I tried multiple sheet_interval options like  - page, table . they all were producing each work sheet for each graph. How to display all in the same second work sheet?

I tried "none" - it was printing in the first worksheet itself.

ods excel
options(
sheet_interval="page"
sheet_name="bar Graphs"
);

proc sgpanel  -1

proc sgpanel -2

proc sgpanel -3

etc

Thanks,

Ana

[Reeza · Accepted solution]

You need none and then to start another page manually.

There used to be a bug in this, but it has a workaround. 

The solution is on here - I posted it from a SAS blog link.

https://communities.sas.com/t5/ODS-and-Base-Reporting/ODS-excel-amp-multiple-sheets/td-p/261953

[SASAna]

Thanks Reeza, It worked so perfectly. Thanks for helping me out.

Thanks,
Ana