Occurs after the chart plots new or changed data, for the Chart object. Occurs after the worksheet is recalculated, for the Worksheet object.
Private Sub object_Calculate()
object Chart or Worksheet. For information about using events with the Chart object, see Using Events with the Chart Object.
Example
This example adjusts the size of columns A through F whenever the worksheet is recalculated.
Private Sub Worksheet_Calculate()
Columns("A:F").AutoFit
End Sub