update charts in Powerpoint

[Steeviee]

Hello gang,

I am fairly confident with Excel have created a number of graphs that have drop down boxes to choose which data is charted. i have been asked if this can be done in powerpoint (at the moment we take 'snapshot' copies and paste them into Powerpoint but would like to have the similar functionality as the Excel document).

Is there a way of linking?

I know that you can put a shortcut to the spreadsheet into Powerpoint but that is worst case solution.

Thank you in advance for any assistance you can offer.

 

[Trevor G]

Copy your Excel Data then Open PowerPoint and select to add a new Slide,

Create a normal Chart on the slide then you should get the Datasheet available to you, then go to the edit menu and select Paste Link.

You may have to refresh the link from time to time if the datasheet remains closed.

 

[Steeviee]

Thanks for the response, Trevor.

Will give it a go.