Plot mean and standard deviation excel

broken image
broken image

‘Set wsh = ActiveSheet’: Assigns the currently active sheet to the ‘wsh’ variable.‘wsh’ (Worksheet): This variable stores the active worksheet.‘pfd’ (PivotField): This variable stores the PivotField object.

broken image
broken image

‘ptb’ (PivotTable): This variable stores the PivotTable object.It optimizes performance by temporarily turning off screen updating and manual updating of the Pivot Table. The code in this method sets the aggregation function of all data fields in the first Pivot Table of the active sheet to calculate the standard deviation.

broken image