Loading ...

Reporting in Excel and PowerPoint

Why OfficeReports InfoGraphics?

Microsoft Office contains functionality to link data from Excel to PowerPoint. It is called OLE (Object Linking and Embedding). Using this technology you can link to Excel charts and ranges in a PowerPoint presentation, in a similar way as OfficeReports InfoGraphics. When the data in Excel changes, the tables and charts in the presentation can be updated. To edit the linked tables and charts you have to double-click them, which will load Excel's user interface and you will be able to edit the Excel chart or range from within PowerPoint. OfficeReports InfoGraphics works different. It simply uses native PowerPoint tables, charts and shapes, and copies whatever information the user has defined (like data, font, background color) from the defined Excel range to the PowerPoint table, chart or shape. Therefore, OfficeReports InfoGraphics has the following advantages over Microsoft OLE:

  • OfficeReports InfoGraphics can link Excel data to native PowerPoint shapes
  • Linked charts and tables are ordinary native PowerPoint charts and tables, and can be edited at all time. Even when the linked workbook is not there anymore!
  • Charts and tables can be designed in PowerPoint, and linked to Excel afterwards. Using OLE, the charts and tables need to be created by using OLE.
  • OfficeReports InfoGraphics enables 'conditional formatting' for native PowerPoint tables, charts and shapes.
  • OfficeReports InfoGraphics can link a specific background color in Excel as an icon in PowerPoint
  • OfficeReports InfoGraphics can link a specific text in Excel as a logo in PowerPoint

For more information about OfficeReports InfoGraphics, please visit our homepage.


Fred Balkenende