Chart.Resize Event

  • Article
Excel Developer Reference

Occurs when the chart is resized.

Syntax

expression.Resize

expression   An expression that returns a Chart object.

Remarks

You must first set the SizeWithWindow property to True before using this event with a chart sheet.

Example

This example keeps the upper-left corner of the chart at the same location when the chart is resized.

Visual Basic for Applications 
  Private Sub myChartClass_Resize()
    With ActiveChart.Parent
        .Left = 100
        .Top = 150
    End With
End Sub

See Also