OfficeReports InfoGraphics Features
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 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 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
- Vertical Line Chart
- Quadrant Chart
- Diverging Bar Chart
- Funnel Chart
Reuse the report definition
- Link to a different or updated workbook, and all tables , charts and shapes will be updated
Collaborate
- Just email the files to colleagues. It will work.
- Use a shared network drive or SharePoint