Refrencing charts on another page

[ionstorm20]

So the issue I have is that I've got all these charts on a page in my sheet called h2h charts and need someone to select a H2H from a list that I have selected, the problem is that there is so much information on the 50-ish charts that I've got a simple if statement is not enough. Any ideas?

 

[Robert Mika]

Hi Ion,
Not very clear.
Can you elaborate that a little bit?
Do you need a dropdown list to selecet a specific chart?

 

[Sektor]

You can only select chart, but you can't get focus to it. To get focus, you should know at least one cell the chart belongs to. Follow this.

First, get charts names and fill combobox with them.

Function GetChartNames() As String()

    Dim cho As ChartObject, i As Integer, arr() As String
    
    With Sheets("h2h")
        ReDim arr(1 To .ChartObjects.Count)
        For Each cho In .ChartObjects
            i = i + 1
            arr(i) = cho.Name
        Next
    End With

    GetChartNames = arr
    
End Function

Sub FillChartsNames()
    Sheets("SOME_SHEET").ComboBox1.List = WorksheetFunction.Transpose(GetChartNames)
End Sub

Then you should calculate a range the charts belongs to. Hint: a range should have some connection with chart name.