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 ...
JonPeltierMVP To clarify, would you use a PivotChart in this other approach? I think that's what you mean, because the PivotChart will automatically show a new column for any new rows that appear in the PivotTable. Then you would just need to select the ranges for the error bars to include the new rows.
Steve_SumProductCom - Yes, I did say pivot chart. This would mean you don't need to update the columns in the chart, just the error bars.
- Thanks. I see that now.