Dynamic Error Bars

  • Thread starter Thread starter A.Geeraert
  • Start date Start date
A

A.Geeraert

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
 
Back
Top