Expanding the solution described in Charts in RPE Documents – the Excel way it is possible to generate Excel chart and embed them in the RPE output Word document as an OLE object. For PDF a snapshot image of the OLE will be automatically generated by RPE.
This solution has several distinct advantages over the initial image based approach:
- the image scales better with the page size
- the chart can be further processed
- simpler to code and maintain in RPE
- greatly improved progress tracking and error information in the RPE console view
The example template and VB Script are available on the RPE devWorks examples wiki page: https://www.ibm.com/developerworks/community/wikis/home?lang=en#!/wiki/Rational Publishing Engine/page/Examples