Louisa has attended:
Excel Intermediate course
Excel/Powerpoint
Hi,
I am trying to merge data between Excel and Powerpoint and have forgotten the best way to do this.
I have got data and a graph in Excel which I want to put into Powerpoint without using copy and paste each time. I want to be able to change the data in Excel so that it automatically updates the data in Powerpoint.
RE: Excel/Powerpoint
Hello Louisa,
Thank you for your question. The best way to link data and charts between Excel and PowerPoint is to copy the Excel content, then go to PowerPoint and click the drop-down section of the Paste button in the Home ribbon. Now, select "Paste Special". In the Paste Special box, select the "Paste link" option on the left.
The box will tell you that it recognises the data as either a Worksheet object or a Chart object. Click OK.
From this point on, any changes made to the Excel data / chart will automatically update in PowerPoint. If PowerPoint is closed when you make the Excel changes, it will update the next time you open the PowerPoint file.
I hope this is helpful.
Kind regards
Marius Barnard
STL
