Automatically Update Charts, Graphs, and Reports in PowerPoint

Here is a neat trick for getting graphs in PowerPoint to automatically update from SQL Reporting Services.


  • Word
  • PowerPoint
  • SQL Reporting Services
  1. Go directly to the report server, not the SharePoint integrated mode. Have it output to HTML,
  2. insert it into a field in Word, then
  3. embed that word document in a PowerPoint slide.


Alternatively, you can render it as an image:

The reason for this is that the SharePoint integration puts in a bunch of AJAX that confuses Word. The report server can produce pure HTML with no Javascript.


Thanks:  Shashank Pawar, his post has some screenshots.

No Comments