chart with changing data source interactive chart

Hello,

I'm trying to make a chart from a pivot table, but only
from certain colunms within that table. Therefore I made a
second table next to it that just equals the pivottable.
From that second table, I made the charts I wanted. If I
change the pivottable, the second table changes equally,
as does the chart. So far so good.

The problem is when the pivottable becomes shorter if due
to a selection in the variables because there are less
results to show. These changes results in a second table
from which the last rows have no values and the chart
which does not adapt itself to the changing data source
and thus giving the last values to be zero.

How can I make the data source of a chart to be
interactive with the changes in the pivottable? Or how can
I make sure that the data source of a chart changes with a
data source wich has grown or diminished?

I would very much appriciate any help.


Thanks,

Feketik