How to cycle through pivotCharts

M

Michael

Helo everyone,

I have 2 pivotcharts. I want to write some sample code that cycles through
the 2 pivotcharts. Any ideas? My sample code doesn't work


For Each wsChart In Charts

Select Case wsChart.Name

Case "CTDefectsByDateChart"
wsChart("CTDefectsByDateChart").Visible = True
wsChart("AgingDefectsChart").Visible = False
Case "AgingDefectsChart"
wsChart("CTDefectsByDateChart").Visible = False
wsChart("AgingDefectsChart").Visible = True
End Select

Next wsChart



Thanks
Michael
 
Top