I am trying to make a flexible 3d bar chart in excel. I made a data
label that will hold all necessary data for the chart and used this
data-label as data range for the chart. Unfortunately excel just uses
the range that the label represent at that time. In other words, when
the data label has changed excel still uses its old value.

Is there a way to overcome this problem?

Thanks in advance,

Douwe