Excel Hack 63: Animate your charts in MS Excel
Here’s a cool trick to get your charts animated in Excel. The magic comes to life through a combination of NA() function, the IF() function, and a counter cell. The counter cell contains the total number of series in your chart, and the series in your chart data will be numbered from 1 to that