fbpx
Site logo white shadow

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

Excel 3D maps

Chart Animation in PowerPoint

Excel Analytics Best Practices

Queries | Comments | Suggestions | Wish list

Subscribe to Blog

Join 1,758 other subscribers

Popular articles

Pivot Table Pro Course

Yes. You use Pivot Tables everyday. Now it is time to find out the real power and nuances. 5.5 hours video, exercises, samples, Q&A.

Excel to Power BI Course

Learn Power BI using the concepts you already know in Excel. Fast transition, in-depth coverage and immediately usable.