I am trying to embed the Summary Section - it will not copy/link to PowerPoint or even group? Is there a better way to do this. These are linked to cells in the workbook so will update when values update.
▬▬▬▬▬▬▬▬▬ Mod edit : thread moved to appropriate forum !
If the objects are inside the Chart as opposed to infront of the chart I would select the Chart
Goto the Home Tab and select the small drop down next to Copy
Copy as Picture
Paste into PP
If the Text Boxes are in front of the chart
Select the cells behind the Chart
Goto the Home Tab and select the small drop down next to Copy
Copy as Picture
Paste into PP
The only issue is that I'm trying to have the Charts linked in PPT - so that when I update the report each week I can "automajically" update all of the charts - there are about 50 charts.
Unless I'm misunderstanding, a chart can be copied/linked between Excel and Powerpoint as well as an individual (or group) of cells (your summary).
After you copy the chart/cells in Excel, use the small down arrow below the Paste in Powerpoint. Click Paste Special. Click the Paste Link radio button and choose MS Excel Chart Object for either chart or cells. Voila!
Your summary section will need to be pre-formatted in Excel prior to pasting. That includes using a white background (otherwise you'll see the grid lines), any font/color/outline formatting, etc.