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)

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