PivotChart (bar graph) of average with standard deviation as error

Priesemut 

After replying to Steve's suggestion, I thought of another approach.

Create a second pivot table: one has averages and standard deviations, the other just averages.

Make a pivot chart using the pivot table with averages only.

Using the approach Steve described (or that I wrote about in Custom Error Bars in Excel Charts), use the standard deviations in the other pivot table to define custom error bars.

This approach makes the chart more dynamic if the pivot table reshapes itself during a refresh, though you may have to reapply the error bars after refreshing the pivot tables.