Just as you can link a table from OfficeConnect for Excel, you can link a chart based on data from your instance and have it updated in OfficeConnect for PowerPoint with just a single click.
Linking a chart is a quicker process than linking a table, because you don’t need to create a named range. The chart is already considered a single discrete object that can be readily copied and linked.
To link an OfficeConnect chart in a PowerPoint slide:
In OfficeConnect for Excel, right-click the chart you want to link, and then click Copy.
In OfficeConnect for PowerPoint, open the presentation and slide where you want to link the chart.
On the OfficeConnect tab, in the Linking group, click Paste Chart.
Be sure to use this command, rather than the regular Paste command. The Paste Chart command ensures the data is linked and can be updated.
The chart is inserted into the slide with a link to OfficeConnect for Excel.
Adjust the position and size of the chart on the slide.
Now, whenever the chart’s underlying data is updated from your instance or from other changes you make in OfficeConnect for Excel, you can quickly update the chart in your PowerPoint slide. On the OfficeConnect tab in PowerPoint, in the Linking group, click Refresh All.