Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

linking powerpoint

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Linking to Powerpoint

Linking to Powerpoint

ResolvedVersion 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

Excel tip:

Quickly insert a function

In Excel 97 and 2000 it was known as the Paste Function dialog box, these days it's known as the Insert Function dialog box. Regardless, one has to choose Insert|Function. or the fx button to open it up. There is, however, a non-mousey way to get hold of the Insert Function dialog box: press Shift+F3 in a blank cell to open the Insert Function dialog.

Press Shift+F3 after a function name and open bracket to open the Function Arguments dialog. For example, type =VLOOKUP( into a cell and press Shift+F3 to obtain a detailed description of VLOOKUP's arguments.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.08 secs.