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
Excel Dashboards.​​​​​

Animation in charts with VBA

Use of Named Formulas, and VBA code to get the animation effect.​​