Connectors

  • Link to an Excel Workbook
  • Link to a database (SQL)
  • Link to an API (JSON)
  • Connect to a datasource using 'R'

Link data to a Table

  • Link to multiple ranges
  • A range may contain empty rows and empty columns
  • The size of the range is variable
  • The size of the table is variable
  • Replace texts by logo images
  • Show background color of linked range (conditional formatting!)
  • Translate background color of linked cells into icons

  • Automatically run a VBA macro

Link data to a Chart

Link data to a Chart
  • Link a range to a chart
  • The range may contain empty rows and empty columns
  • The size of the range is variable
  • Show Category-Axis labels in a Text-Table, giving additional formatting options.

  • Replace texts by logo images

  • Show background color of linked range (conditional formatting!)

  • Translate background color of linked cells into icons

  • Correct overlapping data-labels

  • Automatically run a VBA macro

Link data to a Shape

Link data to a Shape
  • Link a range to a shape
  • Replace texts by logo images
  • Show background color of linked range (conditional formatting!)
  • If the content is too long, devide over multiple slides (Text-lists!)
  • Hide a specific table, chart or shape when this shape is empty
  • Delete a specific table, chart or shape when this shape is empty
  • Delete this slide when this shape is empty (Useful for Report Automation!)
  • Automatically run a VBA macro

New Chart Types

New Chart Types
  • Vertical Line Chart
  • Quadrant Chart
  • Diverging Bar Chart
  • Funnel Chart

Reuse the report definition

Reuse the report definition
  • Link to a different or updated workbook, and all tables , charts and shapes will be updated

Collaborate

Collaborate
  • Just email the files to colleagues. It will work.
  • Use a shared network drive or SharePoint