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 ?

Hi,

In xl2003 the custom error bar reference will take a named range. Are you
using xl2007?

You could always use a static range for the error bars and update that
range.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"A.Geeraert" wrote in message
...
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 ?