刷新一组链接到Excel的PowerPoint图表 [英] Refreshing a set of PowerPoint chart linked to Excel

问题描述

Hi Folks，

• 如果您愿意，将Excel图表链接到PowerPoint幻灯片的最佳方式是什么？能够通过PowerPoint中的代码刷新图表吗？
• 我不是PowerPoint程序员，但我在Access和Excel中做VBA。 
  要通过VBA从PowerPoint内部刷新所有链接图表，适当的代码方法是什么？ 
  我可以在演示文稿中使用"全部刷新"或"每个图表"等内容。 
  

在Windows 7下使用Office 2010。

TIA，

Shane

---

如果此答案解决了您的问题，请选中Mark as Answered。如果此答案有帮助，请单击"投票为有用"按钮。干杯，Shane Devenshire

解决方案

Hi Shane，

感谢您在MSDN论坛上发帖。

我尝试通过Ctrl + C将Excel图表嵌入到演示文稿中并选择"保持源格式化&链接数据"在幻灯片的上下文菜单上。当Excel的数据发生变化时，图表将自动更新。

似乎无需通过代码执行任何操作。如果目标不符合你的目标，请告诉我更详细的目标情景。

祝你有个美好的一天，

Tom

Hi Folks,

• What is the best way to link Excel charts to PowerPoint slides if you want to be able to refresh the charts via code in PowerPoint?
• I am not a PowerPoint programmer but I do VBA in Access and Excel.  To refresh all the linked charts from inside of PowerPoint via VBA what is the appropriate code approach?  Can I use something like Refresh All or For Each chart in Presentation…. 

Am using Office 2010 under Windows 7.

TIA,

Shane

---

If this answer solves your problem, please check Mark as Answered. If this answer helps, please click the Vote as Helpful button. Cheers, Shane Devenshire

解决方案

Hi Shane,

Thanks for posting in the MSDN Forum.

I tried to embedded a Excel chart to Presentation via Ctrl+C and Select "Keep source formatting & Link data" on the Slide's context menu. The chart will be update by itself when the Excel's data has been changed.

There seems needn't do anything via code. Please show me more detailed scenario of your goal if it didn't meet your goal.

Have a good day,

Tom

这篇关于刷新一组链接到Excel的PowerPoint图表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！