Display Excel Data on Map - Simple and Easy : Repost

Displaying excel data on map is a complex task as of now.
First of all you need to have Geocoding (latitude and longitude) of the places you want to map then create a KML map. Use either few sites on net or Google Earth to display map... 
It's quite complex !
Here is a simple trick - Hidden in excel !
This trick helps you display data with ease.
You can also manipulate the data and display it with few excel tricks by using a dash of imagination!
Well, you got to use something called  "Camera Object" in Excel.
First let me tell you where this Camera Object is hiding.... Yes, It's hidden in excel tools and you need to take it out first !
If you are using Excel 2010 here is the navigation to the tool.
File >> Options >> Customize Ribbon
Find the Camera tool  as shown in the picture below...


















If you are using Excel 2003, 

Follow the steps..
Step 1: Go to Tools on the main menu and click Customize.
Step 2: In Customize ,Go to Tools search  and find "Camera".
Now hold that "Camera" and drag this to your to the tool bar on your excel.
Take a look at the Pic below..


















Well, We got the camera tool on our menu now. It's time to get to the map for the data we have.
With regards to the maps, search for right geographic map that meets your needs .You can get enough and more on Google image search. If its a city map rely on Google maps.
Once you find a suitable map download the image and save it for use.
Now,Copy and Paste the downloaded Image of the map on an excel sheet.
Now, we have a Map pasted as an Image in excel and also the data to be displayed.
Go the excel, select the range you want to display on the map
Click on the "Camera" - you will find the range - selected.
Now  - drah it and leave it on the map! 
Adjust the size.
Do a bit of formatting. 
Bingo! You have the object on the map...formatted and perfect!
The magic with this object is it carries the reference with it!  
Just to check, Select the object - you just left on the map. 
You will find its reference in the formula bar !
So, any change you make for the reference cell, the data in the object changes accordingly!

I added Increase and Decrease tabs in demo excel to make data dynamic.
You can use colors, In-cell Graphs, Dynamically change data...using the excel formulae!

Just to ignite thoughts, here are few ideas  to explore this trick
You can use employee photographs or location maps etc display data dynamically.
Rest, I leave to your imagination and innovation......explore it!

Take a look at the outcome.





Download the demo excel here. You can also download @downloads
It's a DO.. CO..MO.. stuff (Download, Copy ,Modify)

No comments:

Post a Comment