Choose chart from drop down list

[whitjm4]

I have 4 different charts to display on a page. I can only display one at a time due to the volume of data. A dashboard with all charts would be too small to read. I would like to use a drop down list to allow the reader to choose the chart to be viewed. I've worked with drop downs for lists but not changing a chart.

 

[Roderick_E]

The charts will be placed on top of each other then you can use the dropdown list to "bring to front". You will add this code to the sheet's Change code (right click the tab, VIEW CODE and paste this in)

Private Sub Worksheet_Change(ByVal Target As Range)
Dim chartfront As String
on error goto 0
If Target.Address = "$A$1" Then
chartfront = Target
ActiveSheet.ChartObjects(chartfront).Activate
    ActiveSheet.Shapes(chartfront).ZOrder msoBringToFront
End If
End Sub

In my code, change $A$1 to the cell where you put the dropdown list.