如何在复制的图形中快速更新链接数据 [英] How to update linked data quickly in copied graph

问题描述

你好，

我有一个工作单，其中包含一年中每个月的预算。现在，我需要添加图表，将信息显示为饼图。

I have a workseet that contains a budget for each month in the year. Now, I need to add graphs that shows that information as a pie chart.

我添加了一个名为"Graphs"的新工作表。在其中，我添加了一个饼图，其选定的数据集对应于"1月"。列，在我的例子中是C列。

I have added a new sheet called "Graphs". Inside it, I have added a pie chart whose selected dataset was the corresponding to "January" column, which in my case is column C.

现在，我必须在其他月份做同样的事情。所以我复制了"1月"。图表并将其粘贴到相同的图表表格中。

Now, I have to do the same for other months. So I copied the "January" graph and pasted it into the same Graphs sheet.

问题是，是否可以更新新图表中所有参考文献的列？例如，对于"二月"，列不是C，而是D，依此类推。

The question is, is it possible to update the column of all references in the new graph? For instance, for "February", column is not C, but D, and so on.

通过手动执行此操作非常困难，所以我想知道Excel是否提供了这样做的方法。

By doing this manually is a very hard work, so I am wondering if Excel provides a way to do this.

问候

Jaime

由C ++提供支持

推荐答案

您好Jaime，

Hi Jaime,

我建议您使用宏代码来获取结果，I将您的主题移动到Excel for developer论坛：

I suggest you use Macro code to get the result, I will move your thread to Excel for Developer forum:

https://social.msdn.microsoft.com/Forums/en-US/home?forum=exceldev

我们建议适当发布的原因是你会得到最合格的受访者群体以及定期阅读论坛的其他合作伙伴可以分享他们的知识，也可以从与我们的互动中学习。感谢您的理解。

The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.

这篇关于如何在复制的图形中快速更新链接数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！