Link OfficeConnect Charts in Slides
Just as you can link a table from OfficeConnect for Excel, you can link a chart based on data from your instance. You can update the chart in OfficeConnect for PowerPoint with a single click.
The following Excel chart types are not available for copying and pasting into OfficeConnect for PowerPoint: Waterfall, Pareto, Funnel, Box and Whisker, Histogram, Sunburst and Treemap.
Linking a chart is quicker than linking a table, because you don't need to create a named range. The chart is already considered a single discrete object that you can copy and link.
To link an OfficeConnect chart in a PowerPoint slide:
- In OfficeConnect for Excel, right-click the chart you want to link, and then selectCopy.
- In OfficeConnect for PowerPoint, open the presentation and slide where you want to link the chart.
- SelectOfficeConnect > Linking >Paste Chart. Use this option instead of the regular Paste option. ThePaste Chartoption ensures the data is linked so you can update it. The chart inserts 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. Select
OfficeConnect > Linking >
Refresh All
.