Animated Charts are not default in Excel.
To make this kind of chart needs advanced skills in Excel with some knowledge of VBA to set the magic.
Knowledge of advanced formulas, and chart formatting tricks can build super
Animation in charts with VBA
Use of Named Formulas, and VBA code to get the animation effect.