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.
This is a good choice if the data is historical and you see little need to update in the future.
However, my charts needs to be edited by some users. Workbook On Error Resume Next 'update first link ppt Workbook. I had copy and paste this vba in powerpoint and this vba is able to run. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).These include column charts, line graphs, pie charts, bar charts, area graphs, scatter graphs, stock charts, surface charts, doughnut charts, bubble graphs, and radar graphs. If you have lots of data to chart, create your chart in Excel, and then copy it into your presentation.This is also the best way if your data changes regularly and you want your chart to always reflect the latest numbers.The Chart Filters button is a more advanced option that shows or hides data in your chart.You can modify the chart in Power Point, including changes to appearance, size or position.