Run the chart as Animate by selecting Month or Whole Year data | VBA & Macros | Excel Forum

Hi,

This is my first post in this site. i am new vba and just started learning . 

i have a workbook which contains three worksheet name called ( Alpha, Bravo,Charlie) and each worksheet there is a chart and i made to display all the chart in one worksheet called (All chart in one) sheet. Now what i need to run the chart as animate of whole year data value or selecting by months wise to see the values in chart by if i click button to start and stop the chart should run as Animate of whole year.

i attached my file for the reference and i found sample video look here in net

sample file i am attaching that i found on other browser. please help me it will be great appreciate to me .

1. i have to animate in worksheet name called ( All chart in one)
2. sample file i attached same like i need to run the chart please...... help me.

if need more additional details please let me know and you can modify the chart as you like of best appearance.