Hi:
If you switch to ODS MSOFFICE2K, you will be creating an HTML file. The HTML file can be opened in Excel 97 or higher. The HTML file can contain a table and your 2 graphs, all on one worksheet. The only difference will be that the graphs will not be panelled -- which means that the 2 graphs would be one underneath the other, instead of side by side.
As for your other question:
Can you pls provide me some detailed notes/ docuemtation on how to use the ODS, customize the TAGSETS for desired styles, and various options available
The ODS documentation is organized primarily by destination -- so there is a section on options for ODS HTML and other ODS MARKUP destinations, there is a section on options for ODS RTF and a similar section for ODS PRINTER-family of destinations. Most of the ODS documentation can be found by starting here at the "Dictionary of ODS Language Statements" topic:
http://support.sas.com/documentation/cdl/en/odsug/61723/HTML/default/a002228116.htm
If you needed to customize style attributes, such as colors and fonts (even if you were sending your HTML output to Excel) -- the appropriate place to change styles is in the STYLE template (not the TAGSET template). Again, looking in the ODS Documentation for PROC TEMPLATE, about STYLE templates is the place to start:
http://support.sas.com/documentation/cdl/en/odsug/61723/HTML/default/a001020001.htm
There have been quite a few user group papers on the subject of styles for tabular output and styles for graphical output -- for both types of output, you would use a STYLE template to make changes. If you were still running SAS 9.1.3, the syntax would be slightly different for your STYLE template than it would be in SAS 9.2, but you should be able to find user-group papers about style templates in SAS 9.1.3 if that is still your version.
As far as SAS/GRAPH customization for colors and fonts, etc, remember that for traditional SAS/GRAPH procedures, like GPLOT, GCHART and GMAP, the "traditional" GOPTIONS, and PATTERN, SYMBOL, AXIS and procedure action statement options will all have an impact on the graphic output. However, for the new SG procedures and ODS GRAPHICS, the traditional methods do not work and you either modify color and font attributes directly in the SG procedure with options or by modifying the style template that you use. (If you look in the SAS/GRAPH documentation, there are quite a few topics devoted to modifying "device-based" or traditional SAS/GRAPH versus modifying "template-based" ODS GRAPHICS output.)
I'd suggest that you try out ODS MSOFFICE2K, using the simplified program below, and see whether the results -- when opened in Excel -- are acceptable.
cynthia
[pre]
ods msoffice2k file="table_graphs.html" style=analysis;
proc report data=sashelp.class(obs=4) nowd;
run;
goptions reset=all cback='white' device= ACTIVEX;
proc gchart data=sashelp.class;
pie3d age / sumvar=height type=mean;
run;
quit;
proc gchart data=sashelp.shoes;
where product contains 'Dress' or product contains 'Casual';
vbar product / sumvar=sales type=mean;
run;
quit;
ods _all_ close;
[/pre]