Calculate Event [Excel 2003 VBA Language Reference]
Occurs after the chart plots new or changed data, for the Chart object. Occurs after the worksheet is recalculated, for the Worksheet object.
objectChart or Worksheet. For information about using events with the Chart object, see Using Events with Embedded Charts.
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