Link data to a Table

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