I have a stacked column graph. This graph updates automatically when I click
another row.

On one of the stacks I have error bars and I want them also automaticilly
updated. But it won't work :
When I enter for example in the 'custom' error bars as cell references $B9
I want it changed to $b10 when I click on row 10. But it doesn't work. When
I click on row 10 and have a look , Excel has changed the cellrefence to
$b$9. So it is not updated.

For the automatical update graph I use defined names. I also made names for
the error bars. But it didn't work.

So : is there a way for automatic plotting of error bars ?