Dynamic Error Bars
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 ? |
Dynamic 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 ? |
All times are GMT +1. The time now is 12:19 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com