Programming Excel with VBA and .NET

Respond to Chart Events

You can write code within a chart’s class to respond to events that occur on the chart. Charts provide these events:

' Chart sheet class
 
Private Sub Chart_Activate(  )
End Sub
 
Private Sub Chart_BeforeDoubleClick(ByVal ElementID As Long, _
  ByVal Arg1 As Long, ByVal Arg2 As Long, Cancel As Boolean)
End Sub
 
Private Sub Chart_BeforeRightClick(Cancel As Boolean)
End Sub
 
Private Sub Chart_Calculate(  )
End Sub
 
Private Sub Chart_Deactivate(  )
End Sub
 
Private Sub Chart_DragOver(  )
End Sub
 
Private Sub Chart_DragPlot(  )
End Sub
 
Private Sub Chart_MouseDown(ByVal Button As Long, ByVal Shift As Long, _
  ByVal x As Long, ByVal y As Long)
End Sub
 
Private Sub Chart_MouseMove(ByVal Button As Long, _
  ByVal Shift As Long, ByVal x As Long, ByVal y As Long)
 
End Sub
 
Private Sub Chart_MouseUp(ByVal Button As Long, _
  ByVal Shift As Long, ByVal x As Long, ByVal y As Long)
End Sub
 
Private Sub Chart_Resize(  )
End Sub
 
Private Sub Chart_Select(ByVal ElementID As Long, _
  ByVal Arg1 As Long, ByVal Arg2 As Long)
End Sub
 
Private Sub Chart_SeriesChange(ByVal SeriesIndex As Long, _
  ByVal PointIndex As Long)
End Sub

The BeforeDoubleClick and Select events return information about the chart item that was clicked. Those arguments are described in Table 16-1 with the GetChartElement topic later.