vba - Is there a way to add clickable hyperlinks to an excel chart's data labels?

Question

I'm trying to make it so when I click on a data label on the chart, I am hyperlinked to a related sheet in the workbook.

Here is a section of the chart. The goal is to be able to click "CSC - RCN" for instance (the label on the bar, not the axis label), and then be hyperlinked to the CSC-RCN sheet of the workbook.

I've tried achieving this with Chart Events like this:

Sub Charts_BeforeDoubleClick()

     If Charts("Chart 1").ElementID = "xlDataLabel" Then

          If Arg1 = "Duration" Then

               If Arg2 = "CSC - RCN" Then
               Worksheets("TIMELINE DATA SHEET").Range("A3").Hyperlinks(1).Follow
               End If

          End If

     End If

End Sub

But I guess I don't know enough about how this works. Am I on the right track? Is there a better way to achieve this effect?

question from:https://stackoverflow.com/questions/66052129/is-there-a-way-to-add-clickable-hyperlinks-to-an-excel-charts-data-labels

Answer 1

Figured it out.

Here is the VBA code I landed on.