Forum Discussion
PivotChart (bar graph) of average with standard deviation as error
Hello everybody out there using Excel, Is there a way to create a PivotChart with a group average as the height of the bars and the standard deviation as the length of the error indicator? I ...
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 https://peltiertech.com/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.
In addition, with two PivotTables, if filtering is needed - better with slicers connected to both.