Extracting PowerPoint Theme and Pasting In Excel

[cappadona]

I have a report that shows sale figures for the company against various indicators. I create this report thru creating graphs directly in Powerpoint. The underlying data however comes from calculations from an Excel File.

I would like to eliminate the need to copying the numbers from Excel and pasting them in to Powerpoint graphs. I plan on just creating graphs in Excel and sending out as a PDF when completed.

The problem is that my company uses these Powerpoint Templates that have the Header bar at the top and a footer bar at the bottom. These are just a yellow bar with small pictures in them. Also, the template has a fancy Title Page.

I would like to extract these headers and footers from out PowerPoint template, paste them within an Excel sheet and set the page breaks. The graphs will go below the header. and when I save/send as PDF, it will look very similar to the first method.

Thanks,
cappa

[6StringJazzer]

I don't know how to do that, or if it's even possible.

However, it is possible to put all your data into an Excel object in PowerPoint, rather than putting all your PowerPoint formatting into Excel.

On the page, Insert, Object, Microsoft Excel Worksheet (it's a misnomer, it will insert an entire workbook).

You can double-click on the object to edit it in Excel. See attached example.

[6StringJazzer]

Another option, which is probably preferable, is to use links in PowerPoint instead of copying data.

From Excel, create the chart you want. Copy it. In PowerPoint Paste Special, Paste as Link. Every time you open the file it will update itself to match whatever is in the Excel file, even if the Excel file is not open. I do this every month. I have a dozen Word documents that are status reports that have links back to Excel charts in a single workbook.