98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Linking to Powerpoint
Linking to Powerpoint
Resolved · Medium Priority · Version 2003
James has attended:
Excel Intermediate course
Excel Advanced course
Linking to Powerpoint
Can I insert graphs and charts into Powerpoint that are linked to excel sheets.
RE: Linking to Powerpoint
Hi James, Thank you for your post, welcome to the forum, certainly you can insert linked objects into your PowerPoint presentations, to do so follow these steps, Open your presentation, on a new slide, choose the menu option, Insert>Object, and from the dialog box choose the option Create From File, If you know the file location type it, if you are not sure use the Browse button, Navigate to your chosen Workbook, select the workbook, you may have to also choose the chartsheet if this is different, when you have selected your chosen object, back in the dialog box you have an option to Link, click this option, and your chartsheet will be inserted with links back to the original, thereafter any changes made to the underlying data which creates the chart will be reflected each time you open your presentation. I hope that has helped, if so please click the Resolved link, best regards Pete
RE: Linking to Powerpoint
Hi Pete,
Thanks for your reply. I am trying to insert a graph into Powerpoint, i have the excel file open and the graph highlighted. In Powerpoint I have folowed the instructions to insert object, and link. In powerpoint it has displayed the data for the graph and not the graph itself - is there a way around this?
RE: Linking to Powerpoint
Hi James, Try saving the chart to a separate sheet, and leave the sheet as the active sheet when you save the workbook, do not open the Excel file, but navigate to it from the Insert>Options and dont forget to link it, I have just tried it out and it works. regards Pete
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. |
Excel tip:Adding Rows or Columns in an Excel 2010 WorksheetIf you want to add a row to an Excel spreadsheet, these are the simple steps you should take: |