Blog

This SlideFab video shows how to create Category Trees automatically. A Category Tree is a structured visualization of corporate spend. It serves for quickly showing where most money goes in terms of categories, sub categories, suppliers and countries.

UPDATE September 9th, 2022. This example still uses a VBA macro to filter the pivot table. With SlideFab v7.0 the VBA macros can be substituted with the pivot field filtering function.

UPDATE: Check out an even simpler and faster way to automate this example using linked charts based on the new SlideFab v1.5. Never the less, the approach below is still valid.

This video is based on a scenario where lots of data in Excel is used to create numerous slides with each having a Powerpoint chart. SlideFab will create the slides and update the data ranges for the charts automatically.

This video is based on a scenario where a table with 1,000 rows in an Excel table shall be brought to Powerpoint. As 1,000 rows are way too much for a single slide, the table shall be spread across multiple slides. Let’s call this Table Spreading. In this video the Slide Loop feature will be used to create 125 slides, where each one holds a Powerpoint table with 8 rows plus header.