Forum home » Delegate support and help forum » Microsoft Powerpoint Training and help » Linking Excel Charts to Powerpoint
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Linking Excel Charts to Powerpoint
Resolved · High Priority · Version 2007
Reply Mon 15 Sep 2008, 16:17Delegate Daniel said...
Daniel has attended:
Powerpoint Introduction course
Powerpoint Intermediate Advanced course
Linking Excel Charts to Powerpoint
Following an Advanced Powerpoint course with yourselves I have been trying to set up a Powerpoint document that links to an Excel document containing several charts that are used in a Powerpoint presentation that we update monthly. Obviously this is intended to save time with updating the Powerpoint presentation by ensuring that all the graphs are updated automatically.
However, I have found that when I link different slides of the Powerpoint presentation to various different graphs within a specific worksheet in Excel this doesn't work properly. Whenever you update links the document updates all the graphs attached to that worksheet to the first Excel chart on the worksheet and not to the individual chart that I had referenced when I set up the link. It is as if Powerpoint cannot differentiate between different charts on the same worksheet and can only cope with one at a time.
This could be solved by rearranging the Excel spreadsheet so that there is a separate worksheet for every Excel chart that I wish to link to. However my question is whether this is necessary or whether there is a way to solve the problem and to get Powerpoint to select a specific chart within a worksheet containing numerous charts?
Thanks
Dan
For upcoming training course dates see: Pricing & availability
RE: Linking Excel Charts to Powerpoint
Hi Daniel
Thank you for your question.
Have you tried copying each chart from Excel into PowerPoint, and pasting each chart by clicking the Paste dropdown arrow, choosing Paste Special and choosing Paste Link?
If not, give this a go with a few of your charts. Then test by closing the PowerPoint presentation, updating some of the Excel data and then reopening the presentation and elect to update the links.
I hope this helps.
Amanda
Reply Tue 16 Sep 2008, 12:45Delegate Daniel said...
RE: Linking Excel Charts to Powerpoint
Thank you for your response Amanda. What you describe is exactly how I have set up the document but I am experiencing problems with some of the links.
When I pasted the charts as links they were all fine but when you close Powerpoint and re-open the document some of the pages reference the wrong chart from the Excel worksheet. Strangely this doesn't happen with all the worksheets.
Is there another way to create these links that would overcome the problem? Or should I just create individual worksheets for each graph?
Dan
RE: Linking Excel Charts to Powerpoint
How weird! I'm not sure how else you would ensure the links work properly apart from setting them up in the way that you describe, by having each chart on an individual worksheet.
Amanda
|