如何使PowerPoint图表反映其数据源的变化? [英] How to make a powerpoint chart reflect changes to its data source?

问题描述

我正在使用openxml sdk 2更改PowerPoint文件中图表的Excel数据(2007年). 我可以更改数据，但是当我在Powerpoint上打开更改的文件时，图表将显示原始数据. 仅当我选择编辑数据"时，它才会显示具有正确数据的Excel工作表，并且图表为 更新.如何使图表反映基本变化?

I'm using openxml sdk 2 to change the excel data from a chart on a powerpoint file (2007). I can change the data but when I open the changed file on powerpoint, the chart shows the original data. Only when I choose "Edit data", it shows the excel sheet with the correct data and the chart is updated. How can I make the chart reflect the underlying changes?

推荐答案

听起来好像您具有嵌入式图表而不是链接的图表.对于嵌入式图表，该图表及其后的电子表格是宿主文档(在这种情况下为PowerPoint文件)的一部分.与原始文件没有任何连接，就像链接的图表或电子表格一样.

It sounds as though you have an embedded chart rather than a linked one. With an embedded chart, the chart and the spreadsheet behind it are part of the host document (PowerPoint file in this case). There's no connection to the original file as there would be with a linked chart or spreadsheet.

这篇关于如何使PowerPoint图表反映其数据源的变化?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！