excel图表中定义的名称不起作用 [英] Defined name in excel's chart doesn't work

问题描述

我需要将一系列数据输入到我的图表中，这些数据会随着时间的推移而发生变化.我认为定义的名称对我有帮助，但即使我遵循教程，它对我也不起作用.我现在有问题，当我尝试将定义的名称设置到图表中时.

I need to input a range of data into my chart, which will be changing over time. I think that defined names will help me, but even when I follow tutorials, it does not work for me. I have problem at the moment, when I trying set the defined name into the chart.

我使用以下教程:TechRepublic - 在 Excel 中构建动态图表的两种方法.我尝试将 counta 更改为 count2 并将 , 更改为 ; 但它仍然不起作用.

I using the following tutorial: TechRepublic - Two Ways to Build Dynamic Charts in Excel. I tried changing counta to count2 and , to ; but it still didn't work.

当我尝试将范围名称添加到图表的标签中时，它返回一个错误.

When I attempt to add the name of my range into the chart's labels, it returns an error.

我试图从一开始就删除 = 符号.名称仅为工作表创建，名称中没有奇怪的字符.但还是什么都没有.

I tried to delete the = sign from the beginning. Names were created just for the sheet, and there are no strange characters in the names. But still nothing.

对于一个范围，我使用此代码(用于 SmithSeries):

For a range I'm using this code (for SmithSeries):

=OFFSET(DynamicChart1!$B$2;0;0;COUNT2(DynamicChart1!$B:$B)-1)

原来是:

=OFFSET(DynamicChart1!$B$2,0,0,COUNTA(DynamicChart1!$B:$B)-1)

并在图表中作为 X 我正在使用:

And into the chart as X I'm using:

=List1!SmithSeries

Excel 返回一条错误消息，指出我可能需要检查公式.我已经按照相同的错误结果学习了几个教程.

Excel returns an error message that says that I may need to check the formula. I've followed several tutorials with the same incorrect result.

推荐答案

好吧，我意识到问题出在 Office 类型上.当我尝试使用其他类型的 Office 为其他 PS 中的图表制作动态范围时，它在那里工作.很高兴知道，当您从 ottehr office 制作一张白纸时，您甚至可以在旧版中对其进行编辑，它仍然有效.

Ok, I realized, that the problem was in type of Office. When I tried to make dynamic range for chart in other PS with other type of Office, it works there. Good to know is that, when you make even blank sheet frm ottehr office, you can edit it even in the old one and it still work.

这篇关于excel图表中定义的名称不起作用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！