Infographic – Convert Excel data to map using any image / floor plan / diagram / schematic

Excel 2013 onwards has a powerful 3D map feature. It can also import any 2D image and plot your data on top of it. Very useful for mapping floor plans, production setup, seating charts, PCBs, IOT sensor data, crop information and more.

Download sample file

Content

1. Intro – 00:00
2. Insert Map – 00:49
3. Import custom image – 01:56
4. Identify coordinates for specific locations on the image – 02:31
5. Add X Y coordinates to map – 03:17
6. Plot Traffic data – 03:46
7. Customize column chart display – 04:19
8. Customize annotations – 04:36
9. Add Date field – 04:52
10. Play by date – 05:26
11. Change to instance display – 06:36
12. Heat map – 07:08

Related videos

Excel 3D maps

Chart Animation in PowerPoint

Excel Analytics Best Practices