在图表中使用的指定范围的偏移公式?-offsetformulafornamedrangetouseinchart?

I am trying to use a (dynamic) named range as the source for my chart. I was hoping to be able to use 1 named range as the source for the chart, but so far, it is not working.

我正在尝试使用一个(动态的)命名范围作为我的图表的来源。我希望能够使用一个命名为range的列表作为这个图表的源，但是到目前为止，它还没有工作。

for example: my data range starts in cel A1 and expands one column at a time to the right. So now the range is A1:E38. tomorrow it is A1:F38 etc.

例如:我的数据范围从cel A1开始，每次向右展开一列。现在范围是A1 E38。明天是A1:F38等等。

So I created a named range with this formula and tried to use it as the source for the chart:

所以我用这个公式创建了一个命名范围，并试图用它作为图表的来源:

=OFFSET('ontwikkeling punten'!$A$1;0;0;COUNTA('ontwikkeling punten'!$A:$A);COUNTA('ontwikkeling punten'!$2:$2)+1)

=抵消(“ontwikkeling punten”! $ 1美元;0;0;COUNTA(“ontwikkeling punten”! A:美元美元),COUNTA(“ontwikkeling punten”! $ 2:2美元)+ 1)

But excel does not accept this a the data source for my chart. When I select the current range, say A1:E38, and create a chart from it, there is no problem at all. Why does excel not accept my dynamic named range as the source for my chart?

但是excel不接受这个作为我的图表的数据源。当我选择当前的范围，比如A1:E38，并从中创建一个图表时，没有任何问题。为什么excel不接受我的动态命名范围作为表格的源?

Otherwise, I would have to create 38 separate data ranges.

否则，我必须创建38个单独的数据范围。

1 个解决方案