Does anyone know if you can create an Excel report and a Gra...

[Les Johnson 3]

I did get a chart on the same tab as my report (using the NOBREAK option) but my question now would be. Can I position the chart so it doesnt overlay on the report

[Les Johnson 3]

Does anyone know if you can create an Excel report and a Graph in the same tab. My first go around using the HTML/Document compound builder put the report and graph on separate tabs.

[Warren Hinchliffe]

A little more info may help, perhaps a sample code we can see

[David Beagan]

Here is a way to do it:

GRAPH FILE ggsales

SUM UNITS

BY REGION

ON GRAPH HOLD AS GIF1 FORMAT GIF

ON GRAPH SET STYLE *

SQUEEZE=ON, ORIENTATION=PORTRAIT, $

TYPE=REPORT, GRID=OFF, $

ENDSTYLE

END

 

TABLE FILE ggsales

HEADING

"</24 "

SUM UNITS

BY REGION

ON TABLE SET PAGE-NUM OFF

ON TABLE PCHOLD FORMAT XLSX

ON TABLE SET STYLE *

TYPE=REPORT, IMAGE=gif1.gif,$

ENDSTYLE

END

[Les Johnson 3]

Thanks for the example.

[David Beagan]

What was your solution

[Les Johnson 3]

Using your example of saving the chart as a gif and placing it in the HEADING.