How to Create Map Chart Animations in Excel 365
Have you ever wondered how to make Animated Charts using Excel? In this video we will learn how to use Visual Basic for Applications (VBA) and Excel to create Map Chart gif Animations. The process is simple: First the raw date is processed, and a Map Chart is created for the first data series. Next, a VBA code is written and run to update the Map Chart with the next set of data and export it as a picture. Finally, an external tool, i.e. https://ezgif.com/maker, is used to stitch all the pictures and create a gif animation. The example I have chosen for this video is the case of US presidential election results. The goal is to create a Map Chart animation to show the party, i.e. Republican (Red), Democrat (Blue), or other (Grey), that won the elections in the different States in the last 100 years.
Raw data used in the example:
https://en.wikipedia.org/wiki/List_of...
Excel Spreadsheet with Raw Data and VBA Code:
https://github.com/Datavigo/Map-Chart...
Timestamps:
1:01 Description of Data
5:44 Visual Basic for Application Code
12:04 Stitching the frames in ezgif.com
Find us at:
🐦 / datavigo
💼 / datavigo
About DataVigo:
Our aim in this channel is to provide you top level training in Data Science and Data Analytics subjects. Whether you are a beginner or would like to sharpen your skills, this channel offers practice based tutorials in a variety of topics such as Python Programming, Machine Learning, Data Extraction, Data Visualisation, and Advanced Excel.
Credits:
Song: MBB - Beach (Vlog No Copyright Music)
Music provided by Vlog No Copyright Music.
Video Link: • MBB - Beach (Vlog No Copyright Music) ( • MBB - Beach (Vlog No Copyright Music) )