Change Data Series In Chart Using Drop-Down List

[raybugge]

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

[Excel Fox]

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

    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

[raybugge]

Excellent
Thanks
Ray