Show stdev errorbars on pivot bar chart

I have made a pivot bar chart using excel 2003, and I would like to
show error bars on this bar chart. The values for the bars are averages
of a certain quantity. The values for the errorbars should be the stdev
of this quantity.

It is possible to add error bars in the existing chart using "Format
data series", but that only works for one particular chart. If I update
the underlying data or plot other quantities, then the errorbars are
gone.

Does anyone know how to solve this problem?

Like all custom formatting in pivot charts, refreshing the data clears the
formatting. Microsoft admits this is a problem, and suggests that you record
a macro, so next time you have to fix it, you won't waste so much time:

http://support.microsoft.com/?id=215904

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

"Pieter" <pbrascamp@gmail.com> wrote in message
news:1144247649.966582.151890@u72g2000cwu.googlegroups.com...
>I have made a pivot bar chart using excel 2003, and I would like to
> show error bars on this bar chart. The values for the bars are averages
> of a certain quantity. The values for the errorbars should be the stdev
> of this quantity.
>
> It is possible to add error bars in the existing chart using "Format
> data series", but that only works for one particular chart. If I update
> the underlying data or plot other quantities, then the errorbars are
> gone.
>
> Does anyone know how to solve this problem?
>