Linked Chart Export Mode

The Linked Chart Export Mode is a very convenient way to automate PowerPoint charts from Excel with SlideFab. It uses the built-in Excel and PowerPoint functionality to keep the charts linked. All SlideFab does is to make sure that the data remains stable in the output slide by breaking the link. However, there is one caveat: Once the link is broken, the chart style can still be edited but not its data.

What it does

SlideFab will detect embedded Excel charts in the PowerPoint template. Instead of showing the field to select the Excel Source Range, it only gives the option to break the link to Excel. This checkbox is ticked by default. It makes sure that the linked charts in the created output presentation do not update when the linked chart in Excel changes.

What it expects from PowerPoint and Excel

Basically, the only requirement is that the Excel chart is copied and pasted as linked chart to PowerPoint.

That a chart in PowerPoint is linked to Excel can be seen in the Chart Design tab where the Refresh Data button becomes visible.

SlideFab 2 Manual Outline

• Documentation
• Think twice before coding VBA from Excel to PowerPoint
• Quickstart to SlideFab 2
• How SlideFab 2 works
• Requirements for SlideFab 2
• The SlideFab 2 ribbon
  • Linking PowerPoint presentations with Excel workbooks
  • The Iteration Loop tab
  • The Slide Linking tab
    • Plain Text Export Mode
    • Table Export Mode
    • Excel Chart Export Mode
    • PowerPoint Chart Export Mode
    • Linked Chart Export Mode
    • Indirect Shape Export Mode
    • Image from File Export Mode
    • Screenshot Export
  • The Advanced settings tab
  • The Logical Audit tab
  • Making slides
  • General Preferences
• Creating think-cell charts with SlideFab 2 automatically
• Invoking slide automation from your own code using VBA and the SlideFab 2 API
• Best practice