Change Data Series In Chart Using Drop-Down List

My workbook has 3 sheets with charts / data in each.....I need to link the charts to the dropdown box so I can choose which chart to view in each sheet. I can view the data series or view each individual data

Thank you

Ray

https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA

https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA

Just give the column range that contains the name of the series as DataSeries, and use the following macro (assigned to your dropdown)

Code:

---

    Dim objDD As Object
    Dim lng As Long
    Set objDD = ActiveSheet.DropDowns("Drop Down 1")
    lng = objDD.Value - 1
    Application.ScreenUpdating = False
    ActiveSheet.Range("SeriesData").EntireRow.Hidden = (lng <> 0)
    If lng Then
        ActiveSheet.Range("SeriesData").Cells(lng).EntireRow.Hidden = False
    End If

---

Check attached file

Excellent
Thanks
Ray