Capture Index of the selected bar in a bar chart.

[Xenaa]

Hi,

Is there any way in VBA to capture the Index of the selected bar in a bar graph. My intention is User will select one bar and run a macro which will take the Index as input and accordingly perform its activity.
Any help is much appreciated.

- Xenaa

 

[Worf]

Welcome to the Board

Are you using a chart sheet or an embedded worksheet chart? The example code below is for the first case; for the latter you will need a class module.

' chart module
Private Sub Chart_Select(ByVal ElementID&, ByVal Arg1&, ByVal Arg2&)
If ElementID = 3 Then
    Select Case Arg2
        Case -1
            MsgBox "All bars were selected."
        Case Else
            MsgBox "Bar #" & Arg2 & " was selected."
    End Select
End If
End Sub

 

[Xenaa]

Thank you so much for the response !!, I was able to do it through Chart Module.