I have a question in regards to using the compound Excel feature in Webfocus.

Here is some code that works with the car file and does essentially what I want it to. It allows for multiple tab Excel files as well as inserting two graphs into the same tab in Excel. It allows me to embed and not float two graph files (gif) into the same Excel Tab. The problem is that the graphs are right on top of each other. Is there a way to position the gif file in an excel tab so I can see both graphs side by side or right underneath each other. I suspect that it must be controlled somehow in the Stylesheet section of the fex but anytime I try to change it to anything other than 'TYPE=REPORT,...' I get an error.

The customer wants one tab in Excel with nine separate graphs, side by side, and they want to be able to see the graphs without being connected to the internet in the excel file. This is the reason that I can't just store the graph files on the server and then call them when the Excel file is opened. They need to be embedded in the Excel file. This code does this but it won't let me position the graphs in the Excel tab. It just stacks them in the Top Left corner of the Excel tab.

Any help would be greatly appreciated.

Keith


COMPOUND LAYOUT PCHOLD FORMAT EXL2K
SECTION=section1,LAYOUT=ON,ORIENTATION=PORTRAIT,PAGESIZE=Letter, $
PAGELAYOUT=1, $
COMPONENT = 'HOLD1',$
COMPONENT = 'HOLD2',$
END

SET COMPONENT='HOLD1'

GRAPH FILE CAR
SUM
SALES
BY COUNTRY
ON GRAPH HOLD AS GIF1 FORMAT GIF
ON GRAPH SET STYLE *
SQUEEZE=ON, ORIENTATION=PORTRAIT, $
TYPE=REPORT, GRID=OFF, FONT='TIMES NEW ROMAN', SIZE=10, $
ENDSTYLE
END

TABLE FILE CAR
SUM
SALES NOPRINT
ON TABLE SET PAGE-NUM OFF
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET STYLE *
TYPE=REPORT,IMAGE=GIF1.GIF,$
TYPE=REPORT,IMAGE=GIF2.GIF,$
ENDSTYLE
END



SET COMPONENT='HOLD2'

GRAPH FILE CAR
SUM
SALES
BY CAR
ON GRAPH HOLD AS GIF2 FORMAT GIF
ON GRAPH SET STYLE *
SQUEEZE=ON, ORIENTATION=PORTRAIT, $
TYPE=HEADING, GRID=OFF, FONT='TIMES NEW ROMAN', SIZE=10, $
ENDSTYLE
END


TABLE FILE CAR
SUM
SALES NOPRINT
ON TABLE SET PAGE-NUM OFF
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET STYLE *
TYPE=REPORT,IMAGE=GIF2.GIF,$
ENDSTYLE
END


COMPOUND END

This message has been edited. Last edited by: Kerry,

The only thing I can think of is to do a template. Store your graphs to specific locations and call them into the template file and then create your spreadsheet in sheet2