lokeshsu
Board Regular
- Joined
- Mar 11, 2010
- Messages
- 178
Hi all,
I am trying to automate charts, and i have done some rnd and found some code to explode the pie chart, but i want to dynamicly click on the chart and that should automate, i need a code where the series name is taken when i click on the graph. Below is the code which i used to explore the chart
I am trying to automate charts, and i have done some rnd and found some code to explode the pie chart, but i want to dynamicly click on the chart and that should automate, i need a code where the series name is taken when i click on the graph. Below is the code which i used to explore the chart
Code:
Sub Macro1()
ActiveSheet.ChartObjects("Chart 1").Activate
ActiveChart.SeriesCollection(1).Select
ActiveSheet.ChartObjects("Chart 1").Activate
ActiveChart.SeriesCollection(1).Points(8).Select
Dim a As Long
a = 1
Do Until a = 76
Selection.Explosion = a
Application.Wait (1)
a = a + 1
Loop
Range("Q5").Select
End Sub