Rudy asks in this post Use a mouse hovering technique to create an interactive chart:

Is it possible to create this interactive chart into interactive candlestick chart to compare two or more charts ?

interactive candlestick excel chart

Hover over a company name and the chart instantly changes data source.

Formula in cell J2:

="Google"&IFERROR(HYPERLINK(MouseHover("Google"),""),"")

Formula in cell J3:

="Apple"&IFERROR(HYPERLINK(MouseHover("Apple"),""),"")

Formula in cell K2:

=ROUNDUP(MAX(Google!D2:D54)*1.03,-1)

Formula in cell K3:

=ROUNDUP(MAX(Apple!D2:D54)*1.03,-1)

Formula in cell L2:

=ROUNDDOWN(MIN(Google!D2:D54)*0.97,-1)

Formula in cell L3:

=ROUNDDOWN(MIN(Apple!D2:D54)*0.97,-1)

User defined function

Function MouseHover(str As String)
With ActiveSheet.ChartObjects("Chart 2")
    If str = "Google" And Sheet1.Range("A1") <> str Then
        Sheet1.Range("A1") = "Google"
        .Chart.SetSourceData Source:=Sheets("" & Range("A1") & "").Range("A2:A54,C2:F54")
        .Chart.Axes(xlValue).MaximumScale = Range("K2")
        .Chart.Axes(xlValue).MinimumScale = Range("L2")
    ElseIf str = "Apple" And Sheet1.Range("A1") <> str Then
        Sheet1.Range("A1") = "Apple"
        .Chart.SetSourceData Source:=Sheets("" & Range("A1") & "").Range("A2:A54,C2:F54")
        .Chart.Axes(xlValue).MaximumScale = Range("K3")
        .Chart.Axes(xlValue).MinimumScale = Range("L3")
    End If
End With
End Function

Download excel *.xlsm file

Interactive candlestick chart.xlsm