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

Creating a Dashboard with VBA requires sound knowledge of the objects involved e.g worksheets, chart elements, range - properties and using formulas in the VBA editor.

The Dashboard on the left was constructed with a bunch of macros modified and written VBA code to add
looping through sheets and formula creation.​​​