Now use the chart from the chart sheet to copy and paste link into PPT.
Open the Excel file, open the PPT file, set the zoom back to 100% and update the links. If some of them don't work correctly, make sure the upper left hand corner of the chart is visible in the Active Window, even if you have to overlay all the charts with a small offset in the upper left hand corner of the worksheet.
Contents © 1995 - 2017 Stephen Rindsberg, Rindsberg Photography, Inc. You may link to this page but any form of unauthorized reproduction of this page's contents is expressly forbidden.
We now turn the microphone over to Brian Reilly, Power Point MVP, who bares all (and grins it) Here's a fairly extensive list of things that happen with Excel linked charts to PPT and what you can do about it.
1 - It is best to put the charts on their own chart sheet.
As the data changes, the dynamic range updates instantly which leads to an update in the chart.