Charts in RPE Documents – the Excel OLE way

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.

rpeactual_ExcelOLEChart

This solution has several distinct advantages over the initial image based approach:

  1. the image scales better with the page size
  2. the chart can be further processed
  3. simpler to code and maintain in RPE
  4. 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

Continue reading “Charts in RPE Documents – the Excel OLE way”