Amazing Chart Animation

Hi All,

Found another amazing Chart animation workbook courtesy of excelhero.com. This one is by far the best i have seen that can be created in Excel without the need of tools like XCelcius or crystal reports etc. I can bet that if you present your data to your clients in this kind of chart, it will be a stand out instantly. But creating such an animation in a chart would require knowledge of VBA and excel objects such as named ranges etc. Let me explain how this animation works:

  • There is a dropdown at the top left corner of the workbook with “North” as the default value.
  • You can select other values such as “South”, “West”, “East” from the dropdown and watch the chart move.
  • You can also change the chart type as Column, Line and Area.

Please catch up with me if you need any more assistance.

Regards,

Vibhor