linking powerpoint

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

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

Linking to Powerpoint

resolvedResolved · 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


 

Excel tip:

Adding Rows or Columns in an Excel 2010 Worksheet

If you want to add a row to an Excel spreadsheet, these are the simple steps you should take:

With your mouse, right click on the row header below where you want the new row to be added. Then, click Insert.

Follow exactly the same steps if you want to add a column to an Excel worksheet, right click on the column header, choose Insert and the new column will be inserted to the left of the selected column.

View all Excel hints and tips


Server loaded in 0.08 secs.