If you use the custom values for error bars, and link these to worksheet
cells, it's easy to have the cell formulas update. When the cells update,
the error bars will adjust. See

http://peltiertech.com/Excel/ChartsHowTo/ErrorBars.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"J@Y" wrote in message
...
I have about 20 worksheets in a work book, all with graphs. One thing they
all have in comon is a Median point that has error bars on it (the median
values are the same for each graph). Is there a way to change the error
bar
values at the same time for all the graphs?